Hi there,

Please consider registering for an account. Registration is free, only takes a minute and will allow you to access members only boards. If you already have an account with us, then click here to log in.

collapse

* Who's Online

  • Dot Guests: 35
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.


Author Topic: Macro to print sheet  (Read 4961 times)

0 Members and 2 Guests are viewing this topic.

WestwegoManTopic starter

  • Administrator
  • Pirogue Pusher
  • *****
  • Posts: 46
  • Age: 50
  • Location: Westwego, La.
    • View Profile
Macro to print sheet
« on: Jan 23, 2015, 5:06 PM »
To print a specific sheet

Code: [Select]
Sheets("sheet1").PrintOut
To print active sheet. (copies optional)

Code: [Select]
ActiveWindow.SelectedSheets.PrintOut Copies:=1
Print a sheet depending on value from another sheet.

Code: [Select]
If Sheets("Sheet1").Range("M30").Value = "1" Then Sheets("sheet2").PrintOut


 


The postings on this site are my own and do not necessarily reflect the views of Jefferson Parish,

fellow employees, members of the public, suppliers or people working on behalf of the parish.


SimplePortal 2.3.6 © 2008-2014, SimplePortal