Brad,

Not sure if I understand you (and let me know if this is not what you were
asking), but all you need to do to use a variable as the parameter for the
Range object:

Dim sCell As String
sCell = "c5"

Range(sCell).Select

--
Charles
www.officezealot.com


"Brad" wrote in message
...
how can I us a variable as a cell location? ie
Range("c5:variable").Select