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 |
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 |
All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com