row number

[fred]

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

 

[Trevor Shuttleworth]

Fred

x=6: rows(x).select

Regards

Trevor

 

[Bob Phillips]

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)