Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to creat an Excel macro that edits cell data, remembering the
edits, not just the resulting value or formula. If, for example, I want to delete all but the last three characters of a cell value, and I record a macro, editing the cell produces a line like: ActiveCell.FormulaR1C1 = "745". But I don't want the specific value. I want the process. I'm essentially asking for RIGHT(R1C1,3), but I can't use that formula in the macro because it would be a circular reference. What am I missing? |
#2
![]() |
|||
|
|||
![]()
If you use the Value property you can just replace the old value with the new
one e.g. ActiveCell.Value = Right(ActiveCell.Value, 3) Regards Rowan "Mind the gaps!" wrote: I'm trying to creat an Excel macro that edits cell data, remembering the edits, not just the resulting value or formula. If, for example, I want to delete all but the last three characters of a cell value, and I record a macro, editing the cell produces a line like: ActiveCell.FormulaR1C1 = "745". But I don't want the specific value. I want the process. I'm essentially asking for RIGHT(R1C1,3), but I can't use that formula in the macro because it would be a circular reference. What am I missing? |
#3
![]() |
|||
|
|||
![]()
I knew this had to be easy. That's why I could never find it in the books.
Rowan, Thank you very much! NotAnExpert, aka MindTheGaps! "Rowan" wrote: If you use the Value property you can just replace the old value with the new one e.g. ActiveCell.Value = Right(ActiveCell.Value, 3) Regards Rowan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) | |||
I have typed in an excel cell and cannot advance to next cell by . | Excel Discussion (Misc queries) | |||
How to switch to edit the cell | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions |