Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why do I get an error message on "Option Explicit"?
Private Sub CommandButton34_Click() Option Explicit Sub testme01() Dim iRow As Long Dim HowMany As Long HowMany = 20 With ActiveSheet For iRow = 52 To (32 * HowMany - 1) + 52 Step 32 If IsNumeric(.Cells(iRow + 3, "I").Value) Then If .Cells(iRow + 3, "I").Value 0 Then .Cells(iRow, "A").Resize(16, 9).PrintPreview '.printout when you're done checking Exit For End If End If Next iRow End With Range("A1").Select End Sub Thank You, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Explicit | Excel Discussion (Misc queries) | |||
option explicit | Excel Discussion (Misc queries) | |||
Implied Option Explicit in XP?? | Excel Programming | |||
Urgent: Object Explicit Error | Excel Programming | |||
Option Explicit and Arrays | Excel Programming |