VBA Cell Position

[MirantMan]

How do I find what the Cell Postion is of an active cell on a sheet?

I want the text value (i.e. "B1"), not the numeric value (i.e. row=1,column=2).

Does that make sense?

 

[LTunnicliffe]

Try:

Range("A1").value = ActiveCell.address

Hope this helps!

 

[MirantMan]

That did. Thanks!