Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Named Ranges in VBA
I need to know how to name a range using VBA. The example as follows does not work.
Selection.Name = "Named Range". What is the correct syntax for this? |
#2
|
|||
|
|||
The syntax is correct. Then Name isn't valid (contains a space).
This worked ok for me: Selection.Name = "Named_Range" Bruce wrote: I need to know how to name a range using VBA. The example as follows does not work. Selection.Name = "Named Range". What is the correct syntax for this? -- Bruce -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |