Current Row number

[Brian]

Can anyone tell me how I can find out the row number of the current active
cell,

something like x = activecell.currentRowNum ?

Thanks
Brian

 

[Geof]

Brian,
x = ActiveCell.Row

I believe.
Geof.

 

[Brian]

thanks, works great

Brian,
x = ActiveCell.Row

I believe.
Geof.

 

[Sambusa]

Sorry may i ask ?


Where i have to run this : x = ActiveCell.Row pls,
Explain to me because i am new in VBA



SAMI

 

[Dave Peterson]

This kind of code is entered in the VBE--where developers write code.

You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm