Script skips rows

[Argentina09]

[COLOR=#333333][FONT=&quot]
Why does excel start to skip rows after a while in an excelsheet when running a VBA script?
 What could be the mistake in the script andwhat could be possible solutions? <o:p></o:p>[/FONT][/COLOR]

[FONT=&quot]Many thanks for answers on this. <o></o>[/FONT]

 

[SQUIDD]

Hi

Well its not normal behaviour.
Could be multiple things going on.
I think everyone will want to see your code to comment.

Dave

 

[Argentina09]

Hi

Well its not normal behaviour.
Could be multiple things going on.
I think everyone will want to see your code to comment.

Dave

Hello.

Unfortunately, the code cannot be posted here. Sorry about this. 
What should one check for when the vba script skps rows?

 

[SQUIDD]

Well. I fear it will be impossible to answer.

But, for example.

A loop with an if statement. Mixed with an offset on if true.

But it really I feel I will be unable to help without the code.

Dave

 

[Argentina09]

SQUIDD: Thank you very much.

Appreciate more input also

 

[Scott Huish]

The first thing I think of when I hear this is that it's a script that is deleting rows.
If this is what you are doing then you want to move backward through the rows not forward and this is why.

Take this simple example:

For x=1 to 10
If Range("A" & x)=7 then Rows(x).Delete
Next x

Now if row 2 was 7 it would delete that row, which would now contain what used to be in row 3. Now when the loop increments it will go to 3, which is now what used to be row 4 because of the deletion.

To modify my example to work correctly:

For x=10 to 1 Step -1
If Range("A" & x)=7 then Rows(x).Delete
Next x

Now if row 2 was 7, it would delete row 2, moving up all rows after and then the loop would move to 1 which still contains its original contents.

 

[Argentina09]

Thank you very much guys

 

[Argentina09]

What could be other examples of reasons why excel skips a row?

 

[MARK858]

Unless you post the code or give a good description of what the code does how do you expect to get a relevant response?