Thread: how to name a range with vba?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
[email protected] excel.steve.kyle@gmail.com is offline
external usenet poster
  
Posts: 3
Default how to name a range with vba?
ActiveSheet.Names.Add Name:="MyName", RefersTo:="=$B$5:$B$25"


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

Reply With QuoteReply With Quote