VBA - returning the activecell row number

[Khazimula]

Hello all,

Was wondering if anyone could help me with a little problem I have. I am trying to use VBA to return the row number of the cell currently selected. I know you can do this in Excel using the Row() function, but I want to do it as part of a Macro. Ideally what I'd like to know is how you can get a list of the function's available in VBA. I'm assuming you can access all the Excel functions in VBA, but I just don't know how and what format they should be written in.

Any help on this would be greatly appreciated!

 

[al_b_cnu]

Hi,

Try

MsgBox Selection.row

 

[Khazimula]

thanks, that worked a treat!