Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Row Expansion | Excel Worksheet Functions | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |