I'm having a difficult time finding a solution to print my workbook in the manner I need it to.
I have a series of sheets for this example lets say 5. I want the VBA code to look at cell A1 on each sheet and print the quantity provided. But I want this in an Array so that if the user prints to file they don't have to name each file potentially 50 times.
Any help would be greatly appreciated.
I have a series of sheets for this example lets say 5. I want the VBA code to look at cell A1 on each sheet and print the quantity provided. But I want this in an Array so that if the user prints to file they don't have to name each file potentially 50 times.
Any help would be greatly appreciated.
