Printing Based on Name Box Ranges

I am trying to write a macro or VBA, whichever is easier (right now feels like macro is) to create a print button that applies print parameters based on the ranges specified in the "Name Box" (box in the top left), based on the last 3 letters of the name, the sheets page layout, print settings and such will vary but I can't figure out how to get VBA to pay attention to the letters in the "Name Box", identify them, and print based on what letters it finds in the last three positions/whether or not they are contained. Could use a hand here, big thanks if anyone can help. Side note, workarounds are a bit of a challenge here, the only way I could find to define each range is with that name box, they need to be comingled within a sheet so I can't make a sheet for each one. The best way I could think was to make a temporary sheet with the range represented by the name, print that sheet with the parameters I need, and then delete that sheet.

Hi, hard to visualise without a sample sheet. Been a long time since I've done any vba macros but, since it's been a couple of hours since you posted this, I'll just give some general thoughts. I get the impression that each "Name" will be an area within the same worksheet. Can you set up an array (or even just a vlookup table) so that when you press the "Print" button it looks up the name and finds the appropriate print range to apply?

Attachment 637081Attachment 637082Attachment 637083
There is an AOP and CHP for each tab (ie Ex1AOP, Ex2AOP) and they refer to a set range which I want to be treated as a print range. In a perfect world, the VBA would "look through" the available names, find one that has 0< "AOP" and those that meet that are printed. I have the print side figured out just not the finding the correct range side.

Your attachments are an invalid type and I can't see them. Please attach a sample workbook so we can not only see what you're talking about, but can experiment with our formulae without having to type in all the data ourselves.

Hope this helps, left in what I was working on but its honestly kind of a mess.

That's a great start, posting a workbook I mean
I'm guessing that pressing the "Print AOP" button is meant to search all other sheets (ex1,ex2,ex3, etc) and print the desired range within each worksheet depending if it meets your criteria.
I can see what you want, but I feel its been way too long since I've used VBA to help you without spending hours, that I don't have, to re-learn
Now that you've posted an example sheet and explained a bit of what you need, I think one of the VBA experts can join in and help.
It would be of benefit to see some data on the other sheets to get an idea of the kind of ranges your wish to print, including examples of what does and does not meet the criteria for printing.

It sounds very doable, I think I did something similar about a decade ago, so you shouldn't have any trouble finding one of these great volunteers to help out.

Good Luck! :D