Replace #N/A with Text

[Mudbutt]

I'm using Excel 2007 and want to know how to replace all #N/A's in column C with the text string "No Del. Date" via VBA.

 

[scottylad2]

I'm using Excel 2007 and want to know how to replace all #N/A's in column C with the text string "No Del. Date" via VBA.

Can you clarify how the #NA are there in the first place? are they the result of a vlookup where there's no match? if thats the case, surround your vlookup in IFERROR like below

=Iferror(Vlookup Here),"NoDel. Dete")

if it's not the result of a Vlookup, can you post a sample of how the #NA is being generated?

 

[Mudbutt]

Good idea. Thank you.