Placeholding blank cells

M3Drivers

New Member
Joined
Mar 20, 2002
Messages
4
I have a spreadsheet which uses xldown to determine the end of a range of a dynamic column. The problem is that when cells are populated but then deleted, it is like they are still there. If you hit CNTRL+END the cursor goes to the last cell of the just-deleted area instead of shifting up to where the new data ends.

Anybody have any ideas as to why this happens and how to make it stop or reset the end of the range? Thanks.
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Hi

Very common this one, sounds like you have deleted the text or numbers from the cells . ment to or accident dont matter this is what i refer to as cleaned up cells thay are still dirty cells that is blank but excel still sees them and if they had text in them still.

FIX:

Select all the empty cells and right click, select clear contence and click, this forces exzcel to didtroy data unconditionally so they are empty cells,

Now try....
 
Upvote 0
Sorry, Jack, this and deleting the columns/ rows, shifting them left/up etc only works if the file is then saved. Excel still thinks they're dirty until you save.
 
Upvote 0
You can also reset the worksheet extent by using ASAP utilities' (see www.asap-utilities.com) Sheets | Reset Excel's last cell menu command.

This utility is freeware!
This message was edited by Mark W. on 2002-03-21 15:55
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top