A way to set print areas by code?
A way to set print areas by code?
(OP)
I just thought of something. Imagine a large spreadsheet with blocks of calculations, each of which produces results necessary for the results of succeeding blocks. Say if upper blocks find pressure in vessel to exceed a certain limit, then the next blocks either proceed accordingly or simply should not be executed and should be printed. It is the next case which interests me. I want to hide out all succeeding blocks of cells from the sheet and dont want these blocks to print.
Thanks in advance.
RE: A way to set print areas by code?
RE: A way to set print areas by code?
I use this in almost all of the spreadsheets I write. You can download some demos at www.mecaconsulting.com which use this method.
Good Luck,
Chris Rosencutter, P.E.
RE: A way to set print areas by code?
It would have taken me months to discover that filter utility.