VBA - returning the activecell row number

Khazimula

New Member
Joined
Jul 15, 2005
Messages
30
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!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,118,381
Messages
5,571,804
Members
412,420
Latest member
Quintankerus
Top