Thread: how do i set an entire row or column to a range?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Brad Vontur Brad Vontur is offline
external usenet poster
  
Posts: 6
Default how do i set an entire row or column to a range?
You're gonna laugh:

set rng = Range("A1").EntireColumn

or

set rng = Range("A1").EntireRow

And they call it BASIC??

-Brad
-----Original Message-----
hi,

how do i set an entire row or an entire column to a range?

thanks!


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

.

Reply With QuoteReply With Quote