My file has blown out.
One sheet has data to AB108 but Ctrl-End insists the data goes to AB1048576. I've tried selecting everything east of AB and deleting and clearing all, and south of row 108 and also deleting and clearing all but the problem is still there. Is the only way around this to delete the sheet and re-create it?
First CLEAR all the empty rows, then DELETE, then save, close, and reopen.
Entia non sunt multiplicanda sine necessitate
Thank you, worked a treat!
You're welcome.
You may also significantly reduce the size of your workbook by saving it as Excel Binary Workbook (.xlsb)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks