Solved: Problem with Program "Excel Diet"

[Cyberdude]

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??

[malik641]

You must have inserted a row...and E65536 was pushed down one...making it no value at all, therefore it becomes a reference error.

Just replace the Ref with E65536 again and you should be okay.

Not sure how to avoid this though if you want to insert a row.:think:

[Cyberdude]

Hi, Joseph! No I didn't insert a row that I recall. It's not the sort of application where I would do that, but I'll check it out to be sure. Perhaps instead of using 65536 I could use something like:
Cells(Rows.Count,"A")
which I think will give me the same result, but dynamically instead of statically. I look at that angle.
Thanx for the assist!