Insert rows between existing data

[Tickla]

Hi there,

I am wanting to insert a whole new row between each row in the existing data (say A2:A10) - A10 being the last cell used in the column

On this new row I am wanting to insert some formulas such as in cell A3 =IF(A2>5,Yes,No).

I am then wanting this to loop through for all the cells in existing data range.

I have looked through the existing posts on this and am still a litttle stuck. I have been able to insert the spacing rows but not not insert the formula beneath.

Im not new to excel, but new to VBA. Any help would be kindly appreciated.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

[tenk283]

Please Login or Register  to view this content.

?

Bit of trouble with the loop... Should get you going in the right direction.