Set range or named range?
- From: "Ian" <me@xxxxxx>
- Date: Wed, 07 Dec 2005 14:31:57 GMT
I am creating a series of sheets where basic data is entered on a userform
then ranges are copied from a lookup sheet are copied to a sheet to create a
configured layout.
To create the ranges I am currently using:
Dim Intra_mA as Range
Set Intra_mA = Worksheets("Lookup").Range("A13:F20")
To copy the range I then use
Intra_mA.Copy Worksheets("Dental").Range("A16")
Would it be easier to create named ranges on the lookup ***, and how would
I then implement the copy routine?
I am thinking this because I just came across an error in my original setup
for one of the sheets which meant I had to insert another line into a range,
thereby offsetting all the ranges below it.
--
Ian
--
.
- Follow-Ups:
- Re: Set range or named range?
- From: Tom Ogilvy
- Re: Set range or named range?
- Prev by Date: Move Column data to rows
- Next by Date: Function that return a a vector or a table
- Previous by thread: Move Column data to rows
- Next by thread: Re: Set range or named range?
- Index(es):