Hi,

It worked fine in Excel 2003. If it is highlighting the "" is usually means
that they aren't "" instead they are four single quotes or they are Word's
special quotes.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Denver" wrote:

=IF(ISERROR(FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF 1:AH1)))),"",FORECAST(COLUMN(),$AF4:AH4,(COLUMN($A F1:AH1))))

I have this formula in my worksheet but a message box pop up
.....The formula you type contains error and it highlights the formula ""


do i miss something here? thanks for any help, I appreciate.