Thread: Selecting ranges with Cells()
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Selecting ranges with Cells()
Hi Robotman

Set Rng = Range("A1").Resize(1,5)


Alternatively:

Set Rng = Cells(1,1).Resize(1,5)


---
Regards,
Norman


Reply With QuoteReply With Quote