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
|