If i am getting what you need.. this should solve it pretty easy:
Private Sub CommandButton1_Click()
just replace sheet1 with the name of your worksheet and range with the range you want to print.
I dont know what you want with the date... do you want that to print also? or do you want it to be added into a cell in the workbook?
[ This Message was edited by: tpgsr on 2002-06-21 11:01 ]