copy range X number of rows until empty issue

Hello All, I have a vba that copies a range of rows from columns Q-AY, the rows can be 1 to whatever (rows are line items on an order, so 1 order can be only 1 item, another order can be 50...).

The vba works but my issue is when it is copying the rows it is adding blank rows which is not making sense i.e. 2 line items but if I step through the macro 22line items are highlighted when I step into the range copy command but I do not see anything wrong with the logic.

Please Login or Register  to view this content.

Thank you for the reply davesexcel, I tried that line but received a type mismatched error.

Originally Posted by AlphaFrog

Another approach

Please Login or Register  to view this content.

AlphaFrog, wow, thank you, I never imagined 3 lines would accomplish the same thing so efficiently, works like a charm. Unfortunately, means I have a heck of a lot more learning to do.