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?

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