Thread: name of range from macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Miroslav Miroslav is offline
external usenet poster
  
Posts: 6
Default name of range from macro
I have command:
ActiveWorkbook.Names.Add Name:="myName", RefersToR1C1:="='mySheet'!R2C1:R20C8"
but the row 20 is changeable. How could I modify the command?
Thanks.
Reply With QuoteReply With Quote