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

Referncing the current cell name in an Excel MACRO
 

c.address


"Doug" wrote:

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