PDA

View Full Version : [SOLVED] Adjust error calculation in VBA



marreco
02-26-2014, 01:27 PM
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
02-26-2014, 03:53 PM
lr = .Cells(.Rows.Count, "A").End(xlUp).Row - 4

marreco
02-27-2014, 09:18 AM
Hi p45cal, i like, very good!

Thank you very much!