View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default 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