LTL1963
New Member
- Joined
- Dec 10, 2004
- Messages
- 31
My Macro to print pages works to a point, I can print the first 50+ pages out of ~400 pages.
The range text in the VBA changes to red part way through the code and when I try to run it I get a Syntax Error that points to the red text range. Code below, BACK02_3() the range is fine, BACK03_3() the range text turned red.
Thank-you for any help.
The range text in the VBA changes to red part way through the code and when I try to run it I get a Syntax Error that points to the red text range. Code below, BACK02_3() the range is fine, BACK03_3() the range text turned red.
Code:
Sub BACK02_3()
ActiveSheet.Unprotect
Range("EL200:GR258").Select
Selection.Interior.ColorIndex = xlNone
Range("EL200:GR258").Select
Selection.PrintOut Copies:=1, Collate:=True
With Selection.Interior
.ColorIndex = 36
.PatternColorIndex = xlAutomatic
End With
Range("EL200").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Sub BACK03_3()
ActiveSheet.Unprotect
Range(“EL300:GR358").Select
Selection.Interior.ColorIndex = xlNone
Range(“EL300:GR358").Select
Selection.PrintOut Copies:=1, Collate:=True
With Selection.Interior
.ColorIndex = 36
.PatternColorIndex = xlAutomatic
End With
Range(“EL300").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Thank-you for any help.