-
Solved: Problem with Program "Excel Diet"
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??
-
-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules