Macro Code for copying separate worksheets into one combined worksheet works but...

[excelflunky]

The following code works great until I figured out the last row in any of the worksheets isn't being copied.
What I have is single invoices (separate workbooks ... only one per workbook) and am selecting the folder of all the workbooks and the code copies the contents and combines all in one sheet:
Using office 2007

(had help with the code so don't understand much of the workings other than it needs to include the last row of info)

Please Login or Register  to view this content.

[maniacb]

Add the red section below

Please Login or Register  to view this content.