See
http://www.microsoft.com/communities...r=US&sloc=&p=1
Sher, please don't crosspost or provide et least a link.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Sher" wrote:
> Hello -
>
> I need to create an "F" Statement that on one sheet I have spend plan and on
> the another sheet I have an ad hoc sheet. I would like a statement that
> states if a field is blank on ad hoc than it is blank on spend plan. Right
> now when I delete a field on the ad hoc it puts Jan 1900 on the spend plan
> field.
>
> Any help would be appreciated.
>
> Thank you,