I have a worksheet that contains (5) rows as a default (B21 thru B25). If the
user needs more rows, he left clicks on an icon which adds another three rows
to the existing (5) rows (B21 thru B28). If the user hits the icon again,
another (3) rows are added. In addition to adding (3) rows, the first new row
looks at the last existing row to pick up on the last ID number which
identifies one row from the other. As an example, if the last existing row ID
was 01.005, when the user adds another (3) rows, the next new row ID will be
01.006 followed by 01.007 and then 01.008. In addition to the ID column
updating the row sequence, I also have other columns that also pass on their
values to the next new row. To accomplish this, if the last row was B25, the
new row will be programmed to look at the cell above and add 1 to it, as an
example of the ID column. Finally the problem. If I have a worksheet in which
multiple rows were added, let's say (25) and the new row length is from B20
to B45 and I decide to delete some or any rows rows between B20 and B45, I
receive a #REF! fault that starts at the row just below the first row I chose
to delete all the way down to the end. What can I do to make sure that when
any row or groups of rows are deleted, the data from the existing row left
will be copied to the rows below? Any help would be appreciated. Thank You,
JAD