Insert-Delete Rows with Formulas Error

Hi,

I have this code that some good friends here in this forum helped put together.

i works great adding and deleting rows on demand and also copying and inserting the formulas except for thistype of formula.

Please Login or Register  to view this content.

I'm getting two types of problems:

1. When I add rows the first cells (K27=K28) do not configure correctly.
example, I add 3 rows those cells become (K28=K31)

2. The other is when i delete a row(s) the first cells (K27=K28) do not configure correctly, they become (K27=#REF!)

These are just examples. The attached file can reproduce what I am trying to write/say...

Any Thoughts?

Hi,

If you want K27 and K28 to be fixed i.e. remain the same all the time, then use absolute cell reference like this:

Please Login or Register  to view this content.

Regards.