Thread: [SOLVED] FOR, IF, NEXT... Error in VBA while attempting a simple code.
View Single Post
  #4  
Old 01-09-2009, 07:38 PM
stanleydgromjr stanleydgromjr is offline
Valued Forum Contributor
  
Join Date: 10 Oct 2008
Location: Northeast Pennsylvania, USA
MS Office Version:Excel 2003, 2007.
Posts: 689
stanleydgromjr has an addiction to Excel
mewingkitty,

Try:

Code:
Option Explicit
Sub Test()

    Dim iFor As Integer
    For iFor = 1 To 10
        If Cells(1, 1) <> 1 Then
            Cells(1, 2) = 2
        End If
    Next iFor

End Sub

Have a great day,
Stan
__________________
Have a great day,
Stan

stanleydgromjr
Windows Vista Business, Excel 2003 and 2007
Reply With Quote