When I insert or delete line the code is not changing.

**Anto_BT** · 09-30-2012, 11:08 AM

Please Login or Register  to view this content.

I have codes like this and when I insert or delete row before 25 it is the same and it is not showing in correct cell.
Idea how to make this?

**xladept** · 09-30-2012, 12:30 PM

You've got to keep track of the row number - r=25; when you insert r=r+1, when you delete r=r-1:

Please Login or Register  to view this content.

**Anto_BT** · 09-30-2012, 12:53 PM

It is showing me a error.

**xladept** · 09-30-2012, 01:30 PM

Hi Anto_BT,

How are you keeping track? What is your insert/delete code?

Re: When I insert or delete line the code is not changing.