Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing ranges ina macro
Hi-
Hopefully someone can help me with this. I have a user, who has a workbook, with 5 worksheets - each of them having a range of data that needs to be printed. Can I create a macro that will print (in one command) each of those ranges on a separate page? I've looked for some ideas on this, but have not been successful - any help is appreciated!!! thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing ranges ina macro
Hi
one way: - start recording a macro - set the print areas - print each sheets separately - stop recording Now use this macro -- Regards Frank Kabel Frankfurt, Germany "cindy" schrieb im Newsbeitrag ... Hi- Hopefully someone can help me with this. I have a user, who has a workbook, with 5 worksheets - each of them having a range of data that needs to be printed. Can I create a macro that will print (in one command) each of those ranges on a separate page? I've looked for some ideas on this, but have not been successful - any help is appreciated!!! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing ranges | Excel Discussion (Misc queries) | |||
Printing ranges | Excel Discussion (Misc queries) | |||
printing Union of Ranges | Excel Worksheet Functions | |||
Printing ranges not remembered | Excel Discussion (Misc queries) | |||
Printing Ranges | Excel Programming |