Thread: iserror to eliminate #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
  
Posts: 313
Default iserror to eliminate #N/A
I have the following code that gives me a #N/A for some cells. I want to
change it to "" using an error statement such as =IF(ISNA(.... Can anyone
assist me here.


wsPh.Range("f6:AD6").Formula = "=IF(f$5<"""",INDEX(CWWType,
MATCH(f$5,CWWDate,0),1),""x"")"
Reply With QuoteReply With Quote