That output gets copied and pasted the various tabs within the workbook. Paste Special (xl Paste All) 'figure out the paste function!!!!!!!!!
// Create a new Microsoft Word application object Microsoft. (I'm an analyst, not a programmer.) And, I'm the so called Excel whiz, so I guess it's time to learn to play with the big guys. (This is only part of it, when printed its 4 1/2 pages.) The runtime error occurs immediately. Private Sub Command Button1_Click() ' Sheets("2-04 Up"). I'll let you know how it goes, and thanks again for your help. Dave - I sent your suggestions down to the tech dept, and they couldn't help me. Select No one here seems to be able to help and I'm stuck. -Helene I don't know why the smile comes up in the middle of the range sorry, it's a D.