=ISBLANK() returns with TRUE - CORRECT
Further: All 13 of my Contracts were "built" using the copy and insert
method without any problem, to-date.
I've also opened the file by the normal file-Open method, rather than thru
my custom menu, than manually recreated the line (ie: not copied and pasted),
but that does not show a positive result, either.

Any further ideas?

"Ken Wright" wrote:

So if you try =ISBLANK() on the cell you think is empty, you get a TRUE,
correct???

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"BEEJAY" wrote in message
...
=IF(D337="Front",1,IF(D337="Rear",1,IF(D337="Both" ,2,0)))
Formula created on new, blank sheet - Works Great
Copy to Contract Sheets - Big Problems
Formula will not return a Zero, (as expected) when D337 is Blank
Checked cell formatting, etc. All the same as the OK Version.
If I select fx so that the function arguments screen pops up, the first
statement shows as TRUE (althought D337 is blank).
When I check fx on the original sheet, (with a blank D337), the first
statement correctly shows as false.
If I do a copy (from the non-working sheet) and insert onto a new, blank
ws,
the formula looks and works fine again.
Does anyone have any idea where I have to look for this one?