Over time, I've seen many a question about the annoyance of excel retaining the "old" used range settings when old data has been cleared from the worksheet.
You know what I mean..... you once had 10,000 rows of data and deleted/cleared 5,000 rows, yet XL still scrolls to row 10,000 when you try to go to the bottom of the datarange.... annoying yes??
This has been well documented around the XL world, but I don't think I've seen it here, other than in thread solutions....
Anyway, any reference to the used range via VBA will reset the value to the current used range.
So, set up a macro in your Personal.xls macro workbook & assign it a shortcut (for ease of use) and just use the following code....
Hope this helps,
' Keyboard Shortcut: Ctrl+e
' resets the used range of the activesheet