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"")"

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"")"

It was the second one entered on one line as:

wsPh.Range("f6:AD6").Formula =
"=IF(ISNA(F$5,"""",IF(f$5<"""",INDEX(CWWType,MATC H(f$5,CWWDate,0),1),""x""))"

"Kassie" wrote:

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"")"

Sorry!
Left out the closing bracket!

It should read "=IF(ISNA(F$5 and then a closing bracket, before the comma
and what follows.

--
HTH

Kassie

Replace xxx with hotmail


"Tony" wrote:

It was the second one entered on one line as:

wsPh.Range("f6:AD6").Formula =
"=IF(ISNA(F$5,"""",IF(f$5<"""",INDEX(CWWType,MATC H(f$5,CWWDate,0),1),""x""))"

"Kassie" wrote:

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"")"

Kassie, thanks for your help. Dave's helped top finish off what we were
working on. Much appreciated.

"Kassie" wrote:

Sorry!
Left out the closing bracket!

It should read "=IF(ISNA(F$5 and then a closing bracket, before the comma
and what follows.

--
HTH

Kassie

Replace xxx with hotmail


"Tony" wrote:

It was the second one entered on one line as:

wsPh.Range("f6:AD6").Formula =
"=IF(ISNA(F$5,"""",IF(f$5<"""",INDEX(CWWType,MATC H(f$5,CWWDate,0),1),""x""))"

"Kassie" wrote:

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"")"