Insert Row Based on Cell Value and Mod Function Help

Hello,

I am trying to create a macro that will bump data into another column/page if the data in the row ="Header" and if the "Header" tag falls on rows 61, 121, 181, etc.

I feel like I am on the right track with the formula I need to use, but just having a hard time getting past some errors.


When I use the formula

Formula:

Please Login or Register  to view this content.

, this returns "0" at all the places I would like to insert an additional row. Therefore I tried the following, but getting "Expected an Expression" error.

Please Login or Register  to view this content.

Take a look at the syntax of the Mod operator.

Artik

Ok, is Mod in VBA different than mod in Excel? Sorry, I'm still learning VBA so that may be a dumb question. It appears that both give the remainder, but I just don't get how I would tell the loop function that if the Current Row is divisible by 60 AND the current cell begins with ";;Result" then add a blank row. Otherwise move to the next row.

Try

Please Login or Register  to view this content.

Artik