Follow-up question: that routine fails if, for example, the user doesn't want to print Sheet2 and therefore A2 is empty (or rather value = ""). Might there be a way to loop through the range and ignore empty cells? Or does that get back into the tricky Array territory?