Hi, pretty new user here. I've been self teaching myself for a while now and am constantly using Google to try and find help and for the most part have done OK, but I'm coming up with blocks on this one.
I have an excel file that based on the results of different checkboxes, I want it to print only certain sections of the document. I've done named ranges to set each print area, and have just a simple macro to start with to see if I could get it to work that looks something like this
Range("Pre_PPAP").PrintOut Copies:=1, Collate:=True
With "Pre_PPAP" being a named range of cells that covers 7 different tabs in the document. When I try to debug through the basically one line of code I get a runtime error 1004 global error.
Haven't found anything that answers what I'm seeing. Is the problem with the named range or with the code in the macro?
Thanks.