Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have four sheets of the same document on one worksheet. I have written a
basic formula that counts the sheets that have data in them and returns a number 1 thru 4. I have also named four ranges 1 thru 4 to reflect sheets 1&2, / 1,2,& 3, /etc. My problem now is, How can I print these only the ranges that this cell calls for? I can add a print button to my sheet but what would the macro look like to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
selecting 2 ranges, 1 Worksheet, printing on 1 page PDF | Excel Discussion (Misc queries) | |||
Printing multiple ranges on one worksheet | Excel Discussion (Misc queries) | |||
printing Union of Ranges | Excel Worksheet Functions | |||
Printing ranges not remembered | Excel Discussion (Misc queries) | |||
automate printing different ranges on 1 worksheet at different tim | Excel Discussion (Misc queries) |