Only print the active sheet you are in

[Pauljj]

I have set up a spreadsheet using the page breaks into 9 sheets. I want to be able to have a print macro that only prints the active sheet you are in. So if my active cell is in page 3 it only prints 1 sheet of page 3

I thought this was simple enough to use the recorder but active sheet seems to print all 9 sheets off


Any ideas please

 

[Andrew Poulsom]

Look here:

http://www.mrexcel.com/forum/showthread.php?t=328446

 

[Pauljj]

Thank you Andrew, now feel bad for having not found it myself