Find and Replace Excel VBA - replace values???[RESOLVED]

[Mitch_s_s]

Using Office 2007, but writing code for excel 2003 in work.

I am trying to replace any cell with the #N/A error, with a unique number
so i will find the first N/A then replace it with 001, then the next would be 002

the problem i am having is when i attempt to find and replace, it isnt allowing me to replace values...
is this new to 2007? when i use find, i can select values, just doesnt show in the drop down for replace.

hope this had made sense, i tend to go off on a tangent lol