Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Rainhard Fischer   on Mar 07 In MS Office Category.

  
Question Answered By: Mason Evans   on Mar 07

are you sure the code is doing what you expect?

Your code will delete row 2, then delete the sixth row and then the 10th.

The problem is that once you delete the second row, the seventh row is now
the sixth row and is the next to be deleted. When deleted, the 10th row is
actually the original twelfth row.

In deletion, unless you keep track, you should start at the end and work
backwards.

Share: 

 

This Question has 11 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Deleting Non-consecutive rows in VBA Or get search suggestion and latest updates.


Tagged: