Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Only Print Pgs W/Info?
Hello,
I have a worksheet that is about 75+ pages that go months/columns 1-120. Information stops and starts again sporadically after month/column 92. Is there a way to set up a macro or tell Excel to only print the pages with information entered into them? I've looked and searched everything and can't find an answer, if one even exists. I have Excel 2003. Thank you, Kim |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Only Print Pgs W/Info?
You can set up a macro to hide/print/unhide
-- Don Guillett Microsoft MVP Excel SalesAid Software "KC521" wrote in message ... Hello, I have a worksheet that is about 75+ pages that go months/columns 1-120. Information stops and starts again sporadically after month/column 92. Is there a way to set up a macro or tell Excel to only print the pages with information entered into them? I've looked and searched everything and can't find an answer, if one even exists. I have Excel 2003. Thank you, Kim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Only Print Pgs W/Info?
Thanks, Don! How would I enter in values to tell Excel which pages to hide
or unhide? I don't work with macros too often, so I'm in unchartered waters. Thanks again! "Don Guillett" wrote: You can set up a macro to hide/print/unhide -- Don Guillett Microsoft MVP Excel SalesAid Software "KC521" wrote in message ... Hello, I have a worksheet that is about 75+ pages that go months/columns 1-120. Information stops and starts again sporadically after month/column 92. Is there a way to set up a macro or tell Excel to only print the pages with information entered into them? I've looked and searched everything and can't find an answer, if one even exists. I have Excel 2003. Thank you, Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I batch print changing info to a template in Excel ? | Excel Discussion (Misc queries) | |||
varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
How do I print same info at start of pages? | Excel Discussion (Misc queries) | |||
How do I print only certain info on my excell sheet IE: no SS# or. | New Users to Excel |