Somehow I got the whole spreadsheet picked up when I use Ctrl+End to go to the end of the active cells. This is creating a spreadsheet size of about 20Meg when it should be about 5Meg. I can't find out how to fix it so the actual active range is around A1:CN706. Can someone help as I do not want to have to redo the whole worksheet as it has a lot of macros tied to it I'd prefer not to have to revise (I'm VBA challenged).
Google is pretty cool:
http://www.accountingweb.com/article...rksheet/221618
Dan
Don't forget to ☆ me if I helped you!
Thanks for the quick response. However it did not work for me.
I tried it in a new clean workbook and also a new clean sheet in my existing workbook. Neither worked. Always went back to TX5000
Any thoughts?
Sometimes you need to use
I'm not sure why. It worked both ways for me when I tested.
Please Login or Register to view this content.
Go to CN706 (if you are totally sure that is the lowest/right-most cell in your WS) - use F5 to get there quick - then delete all rows and columns to the right and below that
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
More Information
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks