Thread: naming a variable range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_27_] Nigel[_27_] is offline
external usenet poster
  
Posts: 25
Default naming a variable range
why isnt this working?

Range("A" & UniqueDataStart & ":" & "A" & DataLast).Select
ActiveWorkbook.Names.Add Name:="S1", RefersTo:=Selection

i just want to named that range S1

Reply With QuoteReply With Quote