delete row

[ccs_1981]

hi all,

good day,

i facing an easy coding here. i delete one row but how to make the cell4 in range go to the up row? i highlight the coding in red color. hope someone can help me.

Please Login or Register  to view this content.

[Simon Lloyd]

this should be what you need:

Please Login or Register  to view this content.

[ccs_1981]

this should be what you need:

Please Login or Register  to view this content.

thanks, but i think my problem still haven't solve yet, it still same.
when delete 1 row it will shift:xlup and still at the same row(next row before delete, just call it as A row), but when go to next row, it will skip the A row.

i highlight in red color, pls help me, thanks.

Please Login or Register  to view this content.

[/

[garretonufer]

perhaps a

Please Login or Register  to view this content.

?

[Simon Lloyd]

The code needs to delete from the bottom up so try this:

Please Login or Register  to view this content.

[ccs_1981]

thanks so much...