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.
Anybody have any ideas as to why this happens and how to make it stop or reset the end of the range? Thanks.