Malik641 I need you again!

I'm trying to write a macro that will do the following: The user will click on a cell, that active cell and everything back to cell A1 gets selected and print area set, then print a number of copies. With the help of your line of code I've gotten it to select the desired range, but it prints out the entire worksheet not just the selected range.

Danno