Try this

Sub test()
Dim rnum As Long
rnum = 45
Range(Cells(rnum, 1), Cells(rnum, 20)).Select
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mcasteel" wrote in message ...

How do I return a row number of an Excel workSheet to use in a
formula?...


Then...

lets soppose I return row number 45. How do I select the columns 1
through 20 in row 45 (45 would need to be a variable that changes)


--
Mcasteel
------------------------------------------------------------------------
Mcasteel's Profile: http://www.excelforum.com/member.php...o&userid=15698
View this thread: http://www.excelforum.com/showthread...hreadid=274302