show the x and y of a cell
 

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

show the x and y of a cell
 

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

Wu wrote:

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