show the x and y of a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wu - 17 May 2008 17:00 GMT

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

Reply to this Message

Dave Peterson - 17 May 2008 17:06 GMT

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

> I have written a macro that the cursor will stop at uncertain cell everytime
> finally.
[quoted text clipped - 6 lines]
> I want that in range("A1") will show --------> 3,3
> if cursor stops at range("B2"), the range("A1") will show ---------> 2,2

Signature

Dave Peterson

Reply to this Message