I am having trouble in excel vs2002 with an if statement that I am trying to
build a hyperlink in.
If D4 if blank I want it to remain blank but if it is not I want to build a
http link.
It comes back but just as text. Doing a find replace after for the = sign
makes it a formula and works. Would like to do it without the find replace.
thanks..

=IF($D4="","","='"&$A$1&"["&F$3&TEXT($D4,"m-d-yy")&".xls]Daily
Schedule'!$AT$54")