See http://www.contextures.com/xlfaqApp.html#Unused

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wescotte" wrote in message
oups.com...
Also, if the user selects multiple rows and deletes them the program
loops this sub for each cell the user is deleting. Is there a simple
way to say If user is deleting rows skip all these checks and just have
the rows removed?


Can't see how.

The reason I need this is when the user deletes quite a few rows at
once it produces a significant lag to complete the check on all the
cells. Also it produces "phantom" cells where they are technically
empty but the scroll bar on the right doesn't adjust correctly. You
could have 5000 rows.. Delete 4999 of them and then save your workbook.
Close it and reopen it and the Excel would still consider the
spreadsheet to have 5000 rows instead of just 1.

So now the user has a scroll bar that is inaccurate and when the user
prints the spreadsheet instead of 1 page it'll produce however many are
needed to display 4999 blank cells.