Thread: Range Offset setup (follow Up)
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Baker John Baker is offline
external usenet poster
  
Posts: 98
Default Range Offset setup (follow Up)
Tom:

A thousand thanks. It works, its simple, and I even understand it.

Best regards

John Baker



"Tom Ogilvy" wrote:

set rng = Cells(rows.count,1).End(xlup)
Range(Range("A2"),rng).Resize(,16).Name = "selectdata"

Reply With QuoteReply With Quote