ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Last cell problem (https://www.excelbanter.com/excel-programming/315477-last-cell-problem.html)

Jac Tremblay[_3_]

Last cell problem
 
Hi everyone,

I'm trying to make a workbook smaller by deleting all the rows and columns
that do not really contain data. I use Ctrl + End to go to the last cell and
then delete all the empty rows and columns making sure I select them by
clicking on the number or letter that identify them. Then, I save the
workbook and check if it worked. Normally, it works fine but I found some
worksheets that do not want to obey...

In one sheet, the last cell is J50 (let's say). All the columns to the right
of J have been masked (width = 0 from column K to IV). When I display the
columns to the right, the last cell is IV50. If I delete all those columns
(from K to IV) in the same manner, the last cell remains the same, IV50.

What could be the problem with that sheet?

Thanks to anyone who can help.
--
Jac Tremblay


All times are GMT +1. The time now is 02:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com