Thread: how to name a range with vba?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default how to name a range with vba?
You missed a double quote:

range("b5:b25).name="myname"
should be
range("b5:b25").name="myname"

Britt wrote:

Hi,

I want to name a range of cells with vba.
I tried: range("b5:b25).name="myname"

but this gives an error.

Thanks
Britt

--

Dave Peterson
Reply With QuoteReply With Quote