Recording a macro using cell name

  • Thread starter Thread starter ErinC
  • Start date Start date
E

ErinC

I want to record a macro that uses the cell name instead
of the address or relative reference. I can go in & edit
the macro afterwards to contain the cell name, but this is
too time consuming for a large project. The reason for
using the cell name is to keep the macro intact even if
the worksheet has rows or columns added later.

Thanks!
~Erin
 
When using the macro recorder, by default, it records the specifi
address rather than a relative reference...

If you would like to submit your post with more information on wha
specifically you are trying to do, perhaps an actionable solution ca
be provided
 
When I record the macro & go into VisualBasic to edit, it
reads:
Range("C10").Select

I would like it to read:
Range("Dal_Fxd_Jan3").Select

where "Dal_Fxd_Jan3" is the name that I have defined for
the cell C10.

I'd like the macro to record this way, or use replace
function that might do the change throughout the
VisualBasic text instead of going in and manually making
the change.

~Erin
 
Back
Top