Adjust error calculation in VBA

[marreco]

Hi

Why my macro creates 5 rows when my guide has only 2 rows?


When I have data from A5 to A10 not the same thing happens.

see the part in yellow

Att

[p45cal]

lr = .Cells(.Rows.Count, "A").End(xlUp).Row - 4

[marreco]

Hi p45cal, i like, very good!

Thank you very much!