Thread: Naming a range with VBA...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steff_DK[_14_] Steff_DK[_14_] is offline
external usenet poster
  
Posts: 1
Default Naming a range with VBA...
This won't work (either...)

sAddr dosn't get accepted as a cell address...


sAddr = ActiveCell.Address
ActiveWorkbook.Names.Add Name:="test"
RefersToR1C1:="=Lister!R1C7:sAddr

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote