Cyberdude
10-20-2005, 11:16 AM
I use the program "Excel Diet" every so often to reduce the size of some of my larger workbooks. Works like a charm!
However, I just changed an Excel formula to be:
=COUNT(INDIRECT("E"&RangeCntBegRow):E65536)+(RangeCntBegRow - 2 )
When I run Excel Diet now, the item "E65536" now becomes !REF#. I have another formula that uses a similar address (A65536) that does the same thing. That was a surprise. What is happening to cause that??
However, I just changed an Excel formula to be:
=COUNT(INDIRECT("E"&RangeCntBegRow):E65536)+(RangeCntBegRow - 2 )
When I run Excel Diet now, the item "E65536" now becomes !REF#. I have another formula that uses a similar address (A65536) that does the same thing. That was a surprise. What is happening to cause that??