Application.Sheet1.PrintOut = property not suported

's Computer Specifications

Application.Sheet1.PrintOut

how do i tell it to print sheet1?

's Computer Specifications

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

"pswanie" wrote:

> Application.Sheet1.PrintOut
>
> how do i tell it to print sheet1?

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Upload Data from Sheet1 on Local Machine to Sheet1 on LAN	ryguy7272	Microsoft Excel Programming	2	3rd Jul 2008 08:40 PM
Not ScreenUpdating with PrintOut Property	Edd	Microsoft Excel Programming	0	7th Feb 2008 01:56 AM
Copy from file1 sheet1/file2 sheet1 last blank row	=?Utf-8?B?VGFzaGE=?=	Microsoft Excel Programming	2	22nd Aug 2007 08:24 PM
Is there a Filename property in PrintOut property	Christian	Microsoft Excel Programming	4	3rd Sep 2004 10:12 PM
printout of object property settings	TJS	Microsoft ASP .NET	0	17th Oct 2003 06:17 PM