View Single Post
  #2   Report Post  
Ashley Frank
 
Posts: n/a
Default if then else statement also using "and"


Amanda,

I have modified your code to show how it should be written

If Range("E2") And Range("F2").Value = "1" Then
Range("A1").Select

End sub
End If
'
End Sub

Ashley


--
Ashley Frank
------------------------------------------------------------------------
Ashley Frank's Profile: http://www.excelforum.com/member.php...o&userid=26488
View this thread: http://www.excelforum.com/showthread...hreadid=483378