S
strataguru
hi,
how do i set an entire row or an entire column to a range?
thanks
how do i set an entire row or an entire column to a range?
thanks
Tom Ogilvy said:Set rngWs = Columns(colNum).Cells
set rngWs = Rows(rowNum).Cells
if you don't use the cells, you will get a range object of size 1 (the
entire column or entire row). Same with the other suggested approached
Set rngWs = cells(1,colNum).EntireColumn
? rngWs.count
1
so if you were going to loop through the cells of the column, you wouldn't.
If you were going to insert a column or set the column width, then you could
proceed without using the cells qualifier.