From Macro in Excel find cursor location eg.C7

K

kt(uk)

Whilst running a Macro, I would like find the row value of the cursor.

eg. if the cursor is in cell F3 then I would expect the result to be 6
 
A

Ardus Petus

ActiveCell.Row will return Row number
Activecell.Cloumn will return Column number

BTW: 6 is the column number of F3!

HTH
 
Top