hi,
I have 4 worksheets that will be combined in one sheet (Product1, Product 2, Product3, Product4)
These sheets are results of filtering (vba) so if there will be only one product so Product 2, product 3 and product 4 are very hidden
I created this code (keep it mind I am newbee) and it's show error if Product 2, Product 3 and Product 4 is in very hidden state.
Sheets("Product1").Select
Range("A4:N1004").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Print_Summary").Select
Range("A4").Select
ActiveSheet.Paste
Sheets("Product2").Select
Range("A4:N1004").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Print_Summary").Select
Range("A1004").Select
ActiveSheet.Paste
Sheets("Product3").Select
Range("A4:N1004").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Print_Summary").Select
Range("A2004").Select
ActiveSheet.Paste
Sheets("Product4").Select
Range("A4:N1004").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Print_Summary").Select
Range("A3004").Select
ActiveSheet.Paste
Bookmarks