Hi Fred,

x = Activecell.Row

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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