Referncing the current cell name in an Excel MACRO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get from inside a VB macro the currently marked cell? 2
Macro adjustment 5
VBA set thick borders around non empty cells in range 0
After Macro runs, no cell activated - what am I missing? 2
Excel Macro to automatically go to the right of the last colored cell 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Validation list with non blanks from different column 3
How to take text from other cells to create a reference to a name 3

Back
Top