Print Selection Macro help

[Jede]

so what I am doing is trying to get a certain selection to print after something is entered into a box. I have tried a couple different variations and have come to this one:

Please Login or Register  to view this content.

This kind of does what I want it to do to a point but I need it to print ONLY if G13 turns green(I already have the formula set up for this) and also to print on 1 page (currently F15-F17 print on 1 page and G15-G17 print on a second page)


Any help would be much appreciated.

[gue2013]

if you want to do it automatically you have to use this worksheet event

Please Login or Register  to view this content.

If you do it manually then

Please Login or Register  to view this content.

cheers

[Jede]

I am not sure if I am inputting these incorrectly or not but neither of these work properly. The Automatic one does not print unless you run the macro via the VBE. The Manual one does print the selection but still prints them both on separate pages(I need them on the same page as if printing a page that only has those items on it.

[gue2013]

My error

Worksheet_ChangeSelection is the wrong event --> must be Worksheet_Change
I do not understand why you cannot use
Range("F15:G17") instead of Range("F15:F17,G15:G17")

in the case the are really separated then union() must be used and a printarea must be set

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jolivanes]

Is there a specific reason why you use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

The latter will print to a single page.
If the thought is that you might want to print non adjacent areas, you might need something like

Please Login or Register  to view this content.

If you want to print A10:A15 and H10:H15 on a single page.

[Jede]

Basically the use is going to be a label for an inventory process. So I only need those 6 cells to print as that's about the size of the label. I am still a newbie when it comes to the scripting side of Excel so I wasn't sure of the proper format to get only those 6 to print.

[Jede]

Thank you Gue your response works great!