I am trying to print out tags for use in our factory. I have it set up so that formulas take each value needed to complete each tag, so there is formulas for up to 500 tags. When I go to print these tags each time I need to select the page #s I want to print to prevent it from printing the blank cells. I have all of my formula's set up to output "" if there is no value. I have a cell that outputs the range needed as a text string, but no matter how I try to input it into the page setup (using indirect) it always just locks in on the range I used to create the initial macro.

Any solution to this would be much appretiated I think ive been siting at my desk for 6 hours trying to figure this out...

Adam Ondrusek
Wilkinson Steel & Metals