| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming Ranges
Hi,
I have used the recorder to Name a range and it gave me the following ActiveWorkbook.Names.Add Name:="Stop1", RefersToR1C1:="=Sheet1!R7C3" I really need to name the range R7C3 with "Stop1" on every sheet in the Active Workbook and some of my workbooks vary in the number of sheets Can someone help me? Thank You |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Naming ranges | Setting up and Configuration of Excel | |||
| Naming Ranges | Excel Discussion (Misc queries) | |||
| naming ranges | Excel Worksheet Functions | |||
| naming ranges | Excel Worksheet Functions | |||
| Naming Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
