ExcelBanter - Application.Sheet1.PrintOut = property not suported

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Application.Sheet1.PrintOut = property not suported (https://www.excelbanter.com/excel-programming/406262-application-sheet1-printout-%3D-property-not-suported.html)

pswanie

Application.Sheet1.PrintOut = property not suported

Application.Sheet1.PrintOut

how do i tell it to print sheet1?

JLGWhiz

Application.Sheet1.PrintOut = property not suported

ActiveSheet.PrintOut
Or Sheets("Sheet1").PrintOut

"pswanie" wrote:

Application.Sheet1.PrintOut

how do i tell it to print sheet1?

JMB

Application.Sheet1.PrintOut = property not suported

Either
Sheet1.PrintOut
Application.Sheets("Sheet1").PrintOut

Assuming the tab name and code name are identical.

"pswanie" wrote:

Application.Sheet1.PrintOut

how do i tell it to print sheet1?

pswanie

Application.Sheet1.PrintOut = property not suported

thanx

"JMB" wrote:

Either
Sheet1.PrintOut
Application.Sheets("Sheet1").PrintOut

Assuming the tab name and code name are identical.

"pswanie" wrote:

Application.Sheet1.PrintOut

how do i tell it to print sheet1?

All times are GMT +1. The time now is 07:01 AM.