Howdy Roderick, welcome to the board (from a Hoosier Alum).
Try using the cells functionality. Here's and example:
MsgBox Range(Cells(3, 7), Cells(62, 7)).Address(False, False)
The columns and rows are reversed, rowindex then column index numbers.
Cheers, Nate Oliver
[ This Message was edited by: NateO on 2002-07-05 12:33 ]