View Single Post
  #3 (permalink)  
Old March 4th, 2008, 08:20 PM
stanleydgromjr stanleydgromjr is offline
Authorized User
Points: 193, Level: 3
Points: 193, Level: 3 Points: 193, Level: 3 Points: 193, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2007
Location: North East Pennsylvania, USA.
Posts: 48
Thanks: 0
Thanked 4 Times in 4 Posts
Default

cronid,

One more thing.

This line of code:
Do Until rwIndex > 4100

may stop around row 4000 if the macro has already deleted 100 or more rows.

When deleting rows, I usually start from the last row of data to the first, with a For Next loop:
For lngLoopCtr = lngLastRow To 1 Step -1
    'your code goes here
Next lngLoopCtr


Have a great day,
Stan

stanleydgromjr

Windows Vista Business and Excel 2003, 2007.