That error doesn't have anthing to do with the formula. My guess is it is
caused by subtotal trying to hide rows.


This is the article that came to my mind when you cited the error:

http://support.microsoft.com/kb/211769/en-us
"Cannot shift objects off sheet" error message when you hide columns in Excel

Perhaps it will give you some insights into the source of your problem.

--
Regards,
Tom Ogilvy


"Abe85" wrote:


Whoops, I spoke too soon. It does not show data in fields which do not
contain data, which I want... but when I try to apply Subtotals, it
gives me the same error message explaining:

"To prevent possible loss of data, Microsoft Excel cannot shift
nonblank cells off the worksheet."

I guess this is because even though the cells are blank, they still
contain a formula.

Any suggestions?

Thanks again.


--
Abe85
------------------------------------------------------------------------
Abe85's Profile: http://www.excelforum.com/member.php...o&userid=35270
View this thread: http://www.excelforum.com/showthread...hreadid=551059