Thread: creation of name range without selection of cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
  
Posts: 83
Default creation of name range without selection of cells
I used the following
row1 = Sheet3.Range("B5").End(xlDown).Row
ActiveWorkbook.Names.Add Name:="task1summary", RefersToR1C1:= _
"=Summary!R5C2:R" & row1 & "C2"
ListBox2.RowSource = "task1Summary"

I wanted all within program

--
Jim at Eagle

Reply With QuoteReply With Quote