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: Ludwik Fischer   on Mar 07

First indeed my code is not doing what was asked for, i.e. delete
rows 2 to 5 and keep row 6, My code is doing just the opposite. I
did not pay enough attention to the question and only read

>This process of delete every four rows  (and it will ALWAYS
> be every four rows) has to be repeated through row A2000


But this is not my question.

Let's say if we were to delete row 2 and then every 4 rows. Then I
guess we do need to delete row 2 and 6 and 10 and 14 , etc... (Which
the code does).
So why go backwards? It is not as if the requirement was to keep
track of every single deletion, update the rows count and then
perform the following deletion.

Am I right or am I completely out...

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: