Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro printing question
HI-
I have a macro set up to print a series of different ranges on several different worksheets within a single workbook. My problem: In several places, if a specific cell=0, I want the macro to skip the next print range and go onto the next. Can I add that somehow to the macro?? and if so, how would I do that?? Any help would be SO appreciated - thanks in advance. cindy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro printing question
As always, you should post YOUR macro for comments.
-- Don Guillett SalesAid Software "cb" wrote in message ... HI- I have a macro set up to print a series of different ranges on several different worksheets within a single workbook. My problem: In several places, if a specific cell=0, I want the macro to skip the next print range and go onto the next. Can I add that somehow to the macro?? and if so, how would I do that?? Any help would be SO appreciated - thanks in advance. cindy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro printing question
Of course you'll need to edit to suit but this should point you in th
right direction Sub PrintNeededSpreadsheets() Sheets("Sheet1").Select if Range("A1").value < "0" then ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True end if Sheets("Sheet2").Select if range("A1").value < "0" then ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True end if ..... End Sub Jorda -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro printing question
Hi-
Thanks for replying - here is the macro... which actually brings up another question..... The first 2 worksheets print are OK. On the "Social Serv" worksheet - I have 2 print ranges; part 1 and part 2 -- I now have them both selected when I set the print area, but what I need is this: Print part 1 If cell K170=0 Do not print part 2 This same senario is true for the other 3 sheets. thanks again for looking at this... Sub newPrint() ' ' newPrint Macro ' Macro recorded 8/9/2004 by cindyb ' ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("B").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("SOCIAL SERV").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("COMMIS").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("AUDITOR").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Sheets("PAYROLL").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub -----Original Message----- As always, you should post YOUR macro for comments. -- Don Guillett SalesAid Software "cb" wrote in message ... HI- I have a macro set up to print a series of different ranges on several different worksheets within a single workbook. My problem: In several places, if a specific cell=0, I want the macro to skip the next print range and go onto the next. Can I add that somehow to the macro?? and if so, how would I do that?? Any help would be SO appreciated - thanks in advance. Cindy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
An IF question plus Printing Macro | Excel Worksheet Functions | |||
macro printing question | Excel Discussion (Misc queries) | |||
Printing Question | Excel Discussion (Misc queries) | |||
Printing question | Setting up and Configuration of Excel | |||
Question about printing | Excel Discussion (Misc queries) |