Hello please help!
I want to set different print areas for a spreadsheet which has week one week two etc. Can i set up 4 macros to have different print areas?
Hello please help!
I want to set different print areas for a spreadsheet which has week one week two etc. Can i set up 4 macros to have different print areas?
Hi, lynds88,
turn on the macro recorder to have a basic look at what´s being recorded, stop the first one and start a second for the difference (get the Desogner ribbon being visible via Options).
The answer is yes, you might use a code like
which is referring to a dynamic range on the AcrtiveSheet and where the print-area could be hard-coded for your needs in every single macro.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Another approach. This allows you to choose which range to print at the time using a simple input box.
- create Named Ranges for each week's data (do not include the header row)
- give them the names week1, week2, week3, week4
- header row is assumed to be the one immediately above the data
- run macro from the sheet containing the data
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks