how to make macro button to print page that has the active cell only?

Originally Posted by Arkadi

Thanks stnkynts
I could not figure out the reason for the error, I don't get it either when I try. I did not fully test, but did run the macro a few times without error. That said, I don't think I tried it when the sheet is completely empty...

sorry your code now working very well without any inefficient ,its my mistake i didnt setup page brakes
thank you very much for helping me and wish you all the best