Hi,

Is this what you are looking for?

Sub SetRanges()
Dim rng As Range

MsgBox "First the column... "
Set rng = Range("G:G")
rng.Select

MsgBox "and now the row... "
Set rng = Range("20:20")
rng.Select

MsgBox "and now back to home. "
Range("A1").Select

End Sub

I hope that helps.

Rick

-----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/

.