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.