From Macro in Excel find cursor location eg.C7
 

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

From Macro in Excel find cursor location eg.C7
 

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

BTW: 6 is the column number of F3!

HTH
--
AP

"kt(uk)" a écrit dans le message de news:
...
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