Hi Tim

take this sub and change it for your purpose:

Sub abb_bla()

Dim cell As Range

For Each cell In UsedRange
cell.Value = cell.Value & "<brSteel (Zinc Plated)"
Next cell

End Sub

hope that helps

Carlo


On Jan 29, 10:51*am, Tim New wrote:
Forgive me, I am new at Excel macros. *I have a spreadsheet with
thousands of cells that now require extra text be added to the existing
data already in the cell. *The extra text is the same for all cells
involved. *I tried creating my own macro using record, doing the steps,
and stop recording but it applies the action to the original cells
rather than any new cells. *I want to add "<brSteel (Zinc Plated)" to
each cell.

Here is what I have so far:
ActiveCell.FormulaR1C1 = "<brSteel (Zinc Plated)"

Thanks for the help!

*** Sent via Developersdexhttp://www.developersdex.com***