Apply Macro to a number of sheets

Hi guys I have these two Macros that will print two ranges from a sheet on two different sheets. :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I need to apply this code to Sheets named "10" all the way to "360" so I just run the macros and it will print these ranges from all the sheets

Also if you have any suggestions on how to turn the 2 macros into one that would be great too!
Please help!!
Thanks

Hi
are your sheets actually named 10 to 360, or are these just the numbers?

if names, try the macro below
if numbers, cut the bit sn = "" & n & "", and use sheets(n).select not sheets(sn).select

Please Login or Register  to view this content.

It worked well for the first sheet, then it stops and tells me "Subscript out of range" Yes, my sheets are named numerically, but I just realized that there is no pattern to them, so they are NOT named 10, 11,12, 13 etc but something like 10,20,40,60,80,120. Is there anyway to print the only the sheets that are named numerically cause I have other tabs in there that I dont need to print!

Thank you so much!

try this:

Please Login or Register  to view this content.

Hi,
The last one almost worked. I need to print Column B with range 1 on one page as well as range 2 on another page. It does that in some in others it doesn't. The one before last again gave me subscript out of range.

Thanks for all your help