Multiple Print Buttons on one Sheet

Hi is it possible to make a print macro for a button?

Im looking to have one every 31 rows, which will print only the area its within.

my spead sheet has data in sections for each week and id like to print 2 pages for each week, the section id like to print are as follows

-week 1 - A1:Y31 & Z1:AQ31 with the button placed in W30 to print both
-week 2 - A32:Y62 & Z32:AQ62 with the button placed in W61 to print both
-week 3 - A63:Y93 & Z63:AQ93 with the button placed in W92 to print both

And so on is this possible? I can attach the spreadsheet if that would help. thanks Mholt.

HI
try the following codes. You can attach it to a single button at the top. On running the macro it asks for the week number and prints the corresponding range.

Please Login or Register  to view this content.

Ravi

Hi Ravi, thanks for helping ats very much appreciated, I tried the macro above and unfortunately It produces a blank sheet when try to print week 1, or any other week, could this be the way im doing it does it need to go within another print macro?

Ive attached an example of the sheet im tryig to print so you may understand where im going wrong.

You will see firstly that although in my first I wrote week one it starts at week 12 but im guessing this will only affect the number I type in the week box that appears.

See if the attached does what you want.

Brieft description:
A command button at the top of the sheet calls a macro which prompts for the week number to be printed.
A dynamic print area is created by searching for the week number and, if found, extending the range from found cell down 30 rows and across the columns.

Your structure looks to be consistent so this should work - at least it does for the several tests I did.

You will have to make a change in column-B where you have the text "Week" and column-C where you have the week number.

These should be one entry in column-B, such as Week 12, Week 13, etc.
I've done for the first several weeks but you'll have to carry it through the remainder of the sheet.

Please Login or Register  to view this content.

Hi with Help I got there =) the following code is what worked thanks for everyones help,

Please Login or Register  to view this content.

Thanks again

Please be sure to mark your thread as solved and don't forget to rate the responses.

Hello all,

susan here i had a million misconceptions about excel but all got cleared here right away this is the bible of excel so to say all you need you get it here right away cheers to the creator.

Cheers!!!

I have a problem with copying values from one cell A1 from sheet1 to another cell A2 to sheet2 with VBA code.
also i want to keep contents from cell A1, and i want when i change contents in cell A1 to copy to cell A2 sheet 2 and the previous
value in cell A2 sheet2 to move in cell A3 sheet2?