I am trying to use the following but it isn't working properly. Can someone
please advise what I am doing wrong?

If Sheets("E").Range("C8").Value = "1" And Sheets("E").Range("C2").Value =
"Yes" Then
Sheets("1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ElseIf Sheets("E").Range("C8").Value = "1" And
Sheets("E").Range("C2").Value = "No" Then
Sheets("1").Select
Rows("24:27").Select
Selection.Delete Shift:=x1Up
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Else
Sheets("STEP 2").Select
End If

Any help would be greatly appreciated....

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

Amanda,

Sorry, mis-understood. It should be

If (Range("E2").Value = "1") And (Range("F2").Value = "YES") Then
Range("A1").Select
Else
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