I have a cell that is a formula with a numerical result. Currently it is in cell J1. I need to have a macro that can set a print area of the range A1 through I & value in of J1. I'm having difficulty coming up with something - any ideas?