Copy rows gives wrong formulas

When you click the ADD NEW ROW button on the LINER QUOTE sheet, it copies row 24 on all the sheets and pastes a new one underneath with all the formulas.
The code is in Module4 - Sub addrows6()

It all works well except in the LINER ITEM SUMMARY SHEET (blue)
Columns J to AQ are hidden
When the first new row is copied, the formulas come out wrong!

For example H25 refrences H25 on another sheet
But J25 refrences C26! It should be C25.

Can anyone figure out why this is happening?

I have added code to unhide the columns before copying, but that doesnt help...

Hi,

I think your problem is the missing tick marks in the name references to other sheets. For example, instead of LINER_QUOTE_CALC!A1, use 'LINER_QUOTE_CALC'!A1.

I tried this out on a couple cells and it seemed to work fine. Let me know if that doesn't work.

Chris

It only seems to jump ahead with the first row thats created.
They all go up by one after that...

I have solved the problem now.

The reason was the order of the sheets.
I was copying a row on a sheet that refrenced cells on another sheet where the new row had not yet been added.
By changing the order, it fixed the problem.