using the macro code you gave me i altered it so that it could insert a line
as well as delete one. that works fine,
however on each page jan - dec their are formulas in colums b threw d , when
i reun the macro to insert a new line i also need to to imput the formulas,

have tried telling it to copy and paste the formulas from the row below the
new row, but cant seem to get it to work with the X variable