Inserting Rows with IF/THEN in a macro

[ncheatherp]

I'm trying to figure out how to write the following logic inside a macro:

IF W19=Y, THEN INSERT 2 ROWS BELOW R19
IF W19=Y AND X19=Y, THEN INSERT 5 ROWS BELOW R19
Then I would like it to loop to the next row of data and do the same thing (until it gets thru each row of data). For example, if 5 Rows were added after R19, it would then look at W26 & X26 next.

I know that anything is possible....this just has me stumped!!

 

[RSXchin]

sorry to be short with you. would you mind sending me a copy of worksheet?

 

[texasalynn]

where did you put the code? Into a module? It has to be in a module in VB editor window.