| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named range in a sheet referred to from another sheet
It works, thanks a lot.
Still I'd like to know what was wrong with my syntax: I asume my named range was "global" for the entire workbook and not just for the sheet the specific cell was in. I have loads of code lines using Range(ThisWorkbook.Names(... so I wonder if I should change them -as well as new references yet to be written- in accordance with your suggestion, and so avoid trouble in the future. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named range on another sheet | Excel Worksheet Functions | |||
| Macro to insert named range in each sheet | Excel Programming | |||
| Recalculate Named Range After Sheet Changes | Excel Programming | |||
| Loop thru named range of second sheet | Excel Programming | |||
| Referencing Named Range in Other Sheet | Excel Programming | |||
Threaded Mode
