VBA Code To Identify Current Row

[MikeG]

Could anyone tell me what I should write in a macro to tell me which is the active row in my spreadsheet?

For example, if cell A4 is currently selected, I was looking to do something in my macro along the following lines:

Myvariable= CurrentRowNumber

and then my variable would be equal to 4.

Thanks,

MikeG

 

[Cindy Ellis]

Myvariable = ActiveCell.Row()

 

[Travis]

Myvariable= Activecell.Row

 

[Smitty]

Try:

Myvariable = ActiveCell.Row

HTH,

 

[MikeG]

Thanks guys.

MikeG