This works great thanks.

I have 2 other worksheets that need to follow the same rule, but the macro print button isn't in the same place, (roughly F9) and it takes the cell name from E21.

This says it subscript out of range so how can I change the print range for these macros? I don't really understand how the range ("A10")makes it work?