iserror to eliminate #N/A
Did you enter this in one line? Which one of the two is giving this error?
--
HTH
Kassie
Replace xxx with hotmail
"Tony" wrote:
I get a 1004 error now. Is this a code format error?
"Kassie" wrote:
Not sure where you are picking up the error, but it would appear that it is
in the latter part of the formula. If so, then try,
wsPh.Range("f6:AD6").Formula = "=IF(f$5<"""",IF(ISNA(INDEX(CWWType,
MATCH(f$5,CWWDate,0),1)),"""",INDEX(CWWType, MATCH(f$5,CWWDate,0),1))"
Not tested though.
Else, you can insert the ISNA bit at the beginning, and say
wsPh.Range("f6:AD6").Formula =
"=IF(ISNA(F$5,"""",IF(f$5<"""",INDEX(CWWType,
MATCH(f$5,CWWDate,0),1),""x""))"
--
HTH
Kassie
Replace xxx with hotmail
"Tony" wrote:
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"")"
|