Dear All,
My file have end row number at 1,048,576 , and collumn at BD while the actual end row number is only 153 and actual end column is AF.
This cause my file too big some file have 60M in size.
Please tell me where is the problem and help me how to trim the unused empty rows and column like that
Thanks and best regards,
Doco
No the extra rows and columns would not cause that, there is probably another problem there.This cause my file too big some file have 60M in size.
If you push end home, where do you end up? If it is not at the last known row and column, start to CAREFULLY delete rows and columns until you got to where you KNOW the last used row and column is.
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
Hi,
If you know that last row with data is 153 and the last column with data is AF, then you could use this code and see if it helps. I would save a copy, then use this code on it to make sure you don't lose anything you meant to keep.
Hope it helps,
Please Login or Register to view this content.
Dan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks