The code doesn't expect to see multiple tables on Sheet1; for .currentregion to work properly here, every table needs to be separated from its neighbour by at least one completely blank/empty row. Deleting the text Table 4 in cell A22 satisfied that in this case.


Still, headers don't match:
You have Product Number in cell A23 of Sheet1, but Product in cell A1 of the Report sheet.
You have a trailing space in cell B23 of Sheet1, but none in cell C1 of the Report sheet.




In the userform you have a textbox called txtResMinC, but you have in the same place on the userform, another textbox called ResMinC, worse, you have a variable in the code ResMinC! I deleted the textbox ResMinC from the Userform.

Attached Files

msofficeforums39312 v2.xlsm (26.9 KB, 10 views)