Referncing the current cell name in an Excel MACRO
Hi there,
Pelase can you tell me how to reference the currect cell name in a macro.
Not the cell value, but the actual cell name (E.g. AB3). I have a loop
through a range of cell and want to know which cell I am current in. See code
below
For Each c In Worksheets("Calc4").Range("E3:CV3").Cells
I need to know where I am between E3 and CV3 by referring programatically to
the cell name (E.g. Cell AB3)
Thanking you
Doug
|