Macro to edit cell data
Posted by Marianne on November 11, 2001 3:12 PM
I am trying to create a macro that will add a word onto the end of the text that is already in the cell. The problem that I am having is that the text in the cell will be different all the time.
For example lets say I had a list of products and wanted to add the word "SOLD" to some of them (in bold preferably).
Printer - SOLD
This is the code that I come up with when I try to record the Macro:
ActiveCell.FormulaR1C1 = "Printer - SOLD"
The problem is that because the formula states "Printer..." that is all I get. I want the text to stay there and only add the word "SOLD." Also, what would be the code to use so that I don't always end up on cell "B8?" I want to stay where I am at.