Fred

x=6: rows(x).select

Regards

Trevor


"fred" wrote in message
om...
Hi

I want to select a row from a standard worksheet and in vba be able to
access that row using a variable.

ie click row 6
in vba use x=6

(familar with dim etc)

thank you

fred