| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referring to a named range on another worksheet
i am getting an error message in my code when trying to refer to a named
range in a different worksheet (not the active sheet). i have a variable "Rng" that refers to a non-contiguous named range on sheet1. a macro on a form control is attempting to copy this range and paste it to sheet2. do i always have to refer to the sheet name with a named range? i.e. sheets("Sheet1").Range("MyRange") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referring to specific cell in named range in Excel formula | Excel Worksheet Functions | |||
| Do not specify worksheet in a named range | Excel Discussion (Misc queries) | |||
| Getting a named range to appear in another worksheet | Excel Discussion (Misc queries) | |||
| How do I use indirect when referring to a named range in a closed | Excel Worksheet Functions | |||
| named range not specific to worksheet | Excel Programming | |||
Threaded Mode
