i need urgent help with a macro

[britta]

Hello around,
thanks for replying.
I wrote a macro in which i comand that
if in one column in Excel doesnt exist a
figure it should write zero. While recording i had no problems and the zero was set, but when i start the macro i get the #NV in the cells without content.
I recorded a makro with the makro recorder.
The following VBA-code was the result:

Columns("D:E").Select
Selection.Replace What:="#NV", Replacement:="0", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
While recording the makro, EVERY "#NV" was replaced by "0".
But when starting the makro nothing happens...

Thanks in advance

Britta



[This message has been edited by britta (edited 11-16-1999).]

[Lyla]

If you may, can you be more clear?