Hi I am really struggling to create code to do the following task and
would really appreciate any help:

I have a workbook containing 52 worksheets (named 1 - 52).

I want the same range (A1:AQ104) to be printed but each worksheet
printed on a seperate page

I want to create a macro that when activated will prompt what range of
worksheets are being selected to print (eg 4-10). I was thinking that
I needed to create a userform to achieve this with two seperate spin
buttons to make reference to the "from" and "to" worksheets.

Any helps at least just to set me off in the right direction would be
greatly recieved.

Thanks all