View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wu Wu is offline
external usenet poster
 
Posts: 36
Default show x and y of the cell

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

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

e.g the cursor stops at C3, then range("A1") shows ---- 3,3

or, the cursor stops at B2, then range("A1") shows ---- 2,2

How to write in macro for this effect?