Insert new row copies foruma one day, doesn't the next.

I've got a spreadsheet that I add to regularly. There is a lot of information in it and a lot of formulas being used, so I need it to copy the formula from the above row (or below row, I'm not picky) when I insert a row. It does this most of the time, however at random, Excel decides to test my blood pressure and it won't copy formulas when I insert rows. When I do updates I'm inserting upwards of a hundred rows at various places in the sheet, so having to manually copy or insert the formulas is way out of the question. Formatting is being copied just fine, though, it's only the formulas that are fidgety.

Whenever I Google this, the answer is always "Oh, here, use this macro to do it..." and I'm calling BS. I know I don't need a macro to do it, it's been doing it just fine for me without one.

Can anybody tell me if there is a setting somewhere or anything else that I need to look into so that I can get on with my work?

Thanks.

Hello darxide23,

Excel will insert formatted, or not, rows without formulae. If you want to insert Rows with formulae included, I don't know of any other way of doing so without VBA.

Unless you manually Insert Rows>Highlight the selection, including the Row just above, and then use the Filldown feature on the Home Tab, which will copy everyting, including Formulae from the top row down as far as your highlighted range goes.

Regards

Hello darxide23,

Thank you for the feedback.

Please try the attached sample Workbook, and change the Code to suit your needs.

Regards

LOL.