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 sheet, 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
--
Bookmarks