View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim New Tim New is offline
external usenet poster
 
Posts: 4
Default creating a macro to add text to existing data already in cell



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 Developersdex http://www.developersdex.com ***