I am trying to find a way to look at a specific worksheet and specific cells within that worksheet and if there is data displayed in that cell (there is a formula in the cell) print that page.
I searched the forum to see if I could write some VBA to do this but it seems most of the code that I found looks for the last cell with data and then sets the print area based upon that.
To be clear....I have a worksheet that has printable pages (A1:H35 is one page, A36:H70 the next, then I1:P35 and so on). The top few rows have hard data that is the same on all. I want to look at a certain cell (E9,M9,E44, etc.) and print that page if there is data (again there is a formula in that cell). I am guessing this is somewhat easy with VBA?? Any help is greatly appreciated.
Bookmarks