Macro that affects just from row 2 to down

[Santy4tas]

Hello dear people,

I have the following macro

Please Login or Register  to view this content.

I want that the macro affects just from row 2 to down. In other words I want the row 1 remains intact because the macro is deleting the first row and I don't want it.

Can you please tell me what I need to change in the code?

Thanks!

[Leith Ross]

Hello Santy4tas,

Try this..

Please Login or Register  to view this content.

[PaulSP8]

You could also just stop the loop when the second row is reached?

Please Login or Register  to view this content.

[sintek]

Please Login or Register  to view this content.