Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default Application.Sheet1.PrintOut = property not suported

Application.Sheet1.PrintOut

how do i tell it to print sheet1?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 247
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not ScreenUpdating with PrintOut Property Edd[_2_] Excel Programming 0 February 7th 08 01:56 AM
Unable to set the Display Alerts property of the application class PhilM[_2_] Excel Programming 6 June 29th 07 11:45 AM
Replace application.RTD property by Application.RTDServers collect John.Greenan Excel Programming 1 July 7th 05 02:05 PM
Learning about the ScrenUpdating property of the Excel application Almamba Excel Programming 1 February 16th 05 04:13 AM
Is there a Filename property in PrintOut property Christian[_6_] Excel Programming 4 September 3rd 04 10:12 PM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"