Hi
I am having a lot of difficulty in creating a macro designed to print preview a set of sheets from a workbook, currently i have a macro that summarises a set of sheets and then filters them by a specified criteria i then want a macro that enables the selected sheets to be printed (print preview at the moment to check output).
The sheet names are in a list in column S.
Here is what i have so far.
However the range gives a type mismatch error.
any help would be most appreciated.
I am having a lot of difficulty in creating a macro designed to print preview a set of sheets from a workbook, currently i have a macro that summarises a set of sheets and then filters them by a specified criteria i then want a macro that enables the selected sheets to be printed (print preview at the moment to check output).
The sheet names are in a list in column S.
Here is what i have so far.
Code:
Sub PrintSheets()
Application.ScreenUpdating = False
Sheets(Range("S1:S166")).PrintPreview , , 1
Sheet1.PrintPreview , , 1
Application.ScreenUpdating = True
End Sub
However the range gives a type mismatch error.
any help would be most appreciated.