Deleting rows VERY slow!
Hi.
I just posted yesterday regarding a named range anomaly, and Garry
(GS) responded with the solution to fixing my named ranges. Thanks
Garry!
The intial reason for the named ranges question, though, was because I
am encountering a massive time delay to just insert or delete a row
(approximately 5 minutes or more!!) I changed the named ranges
Garry's guidance, and everything seemed to be working fine. ...except
for the continued massive time drag to insert or delete rows.
To check things, I first copied the sheet to a new book and tried
deleting a row - no delay at all. This told me that maybe it has
something to do with either conditional formatting and/or named
ranges. So on the original sheet, I removed all conditional
formatting, named ranges, and all worksheet vba code (I have
worksheet_change code that added a hyperlink to a project number when
it was entered). I then selected all blank rows/cells and cleared
contents, and I ensured data filtering was not turned on. But when I
tried to delete a row, it was still EXTREMELY slow (same .
What else might I need to look for to hopefully fix this? It wasn't
always like this. What might have changed to cause this, and how
might I fix it? I thought about just copying all the worksheets (and
VBA modules) into a new workbook, but I'm worried about link issues
then. Any thoughts? Thanks!
Frank
|