print a worksheet out from another worksheet

  • Thread starter rutima - ExcelForums.com
  • Start date
R

rutima - ExcelForums.com

Hi all,
I have a validation list that shows all the worksheets in the
workbook, I want to beable to select the a worksheet from the list
and print it out without having to go to the sheet. Can this be done
if so how?

Cheers
 
R

Ron de Bruin

Hi

With the list in A1 on Sheet1 for example you can use this macro

Sub printtest()
Dim str As String
str = Sheets("Sheet1").Range("A1")
Sheets(str).PrintOut
End Sub
 
Top