Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel |