You don't need a macro.
You just need to use the Find-Replace feature of Excel.

- Select the cells you want to process.
- From the Edit menu, choose Replace
- In the Find What box, enter <0
- In the Replace with box, enter <""
- Click Replace All

Regards,
Edwin Tam

http://www.vonixx.com


----- Minitman wrote: -----

Greetings,

I need to add an If statement to about 100 cells in a row. The cells
contain links to another part of the sheet. Most of the source cells
have formula which produces a "0". I am trying to replace the "0"
with a "". the formula is simple:

=If([Linked Cell]<0,[Linked Cell],"")

Right now I have:

=+[Linked Cell]

I can change it with a series of keystrokes. I tried to make a macro
and that does not work. Macros used to be keystroke recorders, but
not any more. (Sigh)

Is there anyway to make this more automatic?

If there is a way, how many ways are there, anyone know?

TIA

-Minitman