Hi,

Try this

Sheets("Test").Range("A1:Z1").PrintOut