show the x and y of a cell

[Wu]

I have written a macro that the cursor will stop at uncertain cell everytime
finally.

when the cursor stop, I would like to show the x and y of the cell at
range("A1")

For example, after running the marco, the cursor stop at range("C3")

I want that in range("A1") will show --------> 3,3
if cursor stops at range("B2"), the range("A1") will show ---------> 2,2

 

[Dave Peterson]

Is that row,column?

If yes, you could use:

dim myCell as range
....
with activesheet
set mycell = .cells(33, 11) 'however your macro stops????
with .range("a1")
.numberformat = "@" 'text
.value = mycell.row & "," & mycell.column
end with
end with