A couple of ways:

For only one column -

Range("A" & iFirstRow & ":A" & iLastRow)

where ifirstrow and ilastrow are the row range. Or-

Range(Cells(iFirstRow, iFirstCol), Cells(iLastRow, iLastCol))

to select from multiple contiguous rows and columns.



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