| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I edit cell contents with a macro in Excel?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
