Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
How do I add this line of code if c < 100 the goto next counter Here id my code Sub doprint() ' ' doprint Macro ' Macro recorded 9/25/2003 by AvilaJ Dim i As Integer Dim oCell As Range Dim cCell As Range Dim p As Long strjobnumber = InputBox("Start in Job Number?", " First Job to Print", 0) endjobnumber = InputBox("Finish in Job Number?", " Last Job to Print", 0) Range("I40").Select Range("I41").Select For counter = strjobnumber To endjobnumber Application.ScreenUpdating = False Sheets("Pieces").Activate Range("L5").Value = counter Range("J85").Select c = ActiveCell.Value If c < 100 Then Next counter End If Range("J80").Select p = ActiveCell.Value Sheets(Array("BatchSheet1", "BatchSheet2", "BatchSheet3", "BatchSheet4", _ "BatchSheet5", "BatchSheet6", "BatchSheet7", "BatchSheet8", "BatchSheet9", _ "BatchSheet10", "BatchSheet11", "BatchSheet12", "BatchSheet13", "BatchSheet14", _ "BatchSheet15", "BatchSheet16", "BatchSheet17", "BatchSheet18", "BatchSheet19", _ "BatchSheet20")).Select Sheets("BatchSheet1").Activate ActiveWindow.SelectedSheets.PrintOut From:=1, To:=p, Copies:=1, Collate _ :=True Application.ScreenUpdating = True Next counter Sheets("Pieces").Activate Range("$A$1").Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
you could try
if c < 100 then c = c +1 -- Gary Keramidas "Little Penny" wrote in message ... How do I add this line of code if c < 100 the goto next counter Here id my code Sub doprint() ' ' doprint Macro ' Macro recorded 9/25/2003 by AvilaJ Dim i As Integer Dim oCell As Range Dim cCell As Range Dim p As Long strjobnumber = InputBox("Start in Job Number?", " First Job to Print", 0) endjobnumber = InputBox("Finish in Job Number?", " Last Job to Print", 0) Range("I40").Select Range("I41").Select For counter = strjobnumber To endjobnumber Application.ScreenUpdating = False Sheets("Pieces").Activate Range("L5").Value = counter Range("J85").Select c = ActiveCell.Value If c < 100 Then Next counter End If Range("J80").Select p = ActiveCell.Value Sheets(Array("BatchSheet1", "BatchSheet2", "BatchSheet3", "BatchSheet4", _ "BatchSheet5", "BatchSheet6", "BatchSheet7", "BatchSheet8", "BatchSheet9", _ "BatchSheet10", "BatchSheet11", "BatchSheet12", "BatchSheet13", "BatchSheet14", _ "BatchSheet15", "BatchSheet16", "BatchSheet17", "BatchSheet18", "BatchSheet19", _ "BatchSheet20")).Select Sheets("BatchSheet1").Activate ActiveWindow.SelectedSheets.PrintOut From:=1, To:=p, Copies:=1, Collate _ :=True Application.ScreenUpdating = True Next counter Sheets("Pieces").Activate Range("$A$1").Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
think i missed your meaning
If c < 100 Then goto NxtCntr ... .. .. Copies:=1, Collate _ :=True Application.ScreenUpdating = True NxtCtr: Next counter -- Gary Keramidas "Little Penny" wrote in message ... How do I add this line of code if c < 100 the goto next counter Here id my code Sub doprint() ' ' doprint Macro ' Macro recorded 9/25/2003 by AvilaJ Dim i As Integer Dim oCell As Range Dim cCell As Range Dim p As Long strjobnumber = InputBox("Start in Job Number?", " First Job to Print", 0) endjobnumber = InputBox("Finish in Job Number?", " Last Job to Print", 0) Range("I40").Select Range("I41").Select For counter = strjobnumber To endjobnumber Application.ScreenUpdating = False Sheets("Pieces").Activate Range("L5").Value = counter Range("J85").Select c = ActiveCell.Value If c < 100 Then Next counter End If Range("J80").Select p = ActiveCell.Value Sheets(Array("BatchSheet1", "BatchSheet2", "BatchSheet3", "BatchSheet4", _ "BatchSheet5", "BatchSheet6", "BatchSheet7", "BatchSheet8", "BatchSheet9", _ "BatchSheet10", "BatchSheet11", "BatchSheet12", "BatchSheet13", "BatchSheet14", _ "BatchSheet15", "BatchSheet16", "BatchSheet17", "BatchSheet18", "BatchSheet19", _ "BatchSheet20")).Select Sheets("BatchSheet1").Activate ActiveWindow.SelectedSheets.PrintOut From:=1, To:=p, Copies:=1, Collate _ :=True Application.ScreenUpdating = True Next counter Sheets("Pieces").Activate Range("$A$1").Select End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
change If c < 100 Then Next Counter
to: ------------------------------------------------- If c < 100 Then goto NextCounter ------------------------------------------------ and the at your Next Counter make it: -------------------- NextCounter: ---------------------------- (note the : at the end ) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
oops sorry ignore this my mis read.......... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I "if statement"
Thanks everyone that worked...............
On Fri, 25 Aug 2006 18:03:42 -0400, Little Penny wrote: How do I add this line of code if c < 100 the goto next counter Here id my code Sub doprint() ' ' doprint Macro ' Macro recorded 9/25/2003 by AvilaJ Dim i As Integer Dim oCell As Range Dim cCell As Range Dim p As Long strjobnumber = InputBox("Start in Job Number?", " First Job to Print", 0) endjobnumber = InputBox("Finish in Job Number?", " Last Job to Print", 0) Range("I40").Select Range("I41").Select For counter = strjobnumber To endjobnumber Application.ScreenUpdating = False Sheets("Pieces").Activate Range("L5").Value = counter Range("J85").Select c = ActiveCell.Value If c < 100 Then Next counter End If Range("J80").Select p = ActiveCell.Value Sheets(Array("BatchSheet1", "BatchSheet2", "BatchSheet3", "BatchSheet4", _ "BatchSheet5", "BatchSheet6", "BatchSheet7", "BatchSheet8", "BatchSheet9", _ "BatchSheet10", "BatchSheet11", "BatchSheet12", "BatchSheet13", "BatchSheet14", _ "BatchSheet15", "BatchSheet16", "BatchSheet17", "BatchSheet18", "BatchSheet19", _ "BatchSheet20")).Select Sheets("BatchSheet1").Activate ActiveWindow.SelectedSheets.PrintOut From:=1, To:=p, Copies:=1, Collate _ :=True Application.ScreenUpdating = True Next counter Sheets("Pieces").Activate Range("$A$1").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
Call a sub statement in "Personal Macro Workbook" from "ThisWorkbo | Excel Programming | |||
vba: How do I write a "For Each Statement" nested in a "With Statement"? | Excel Programming |