Multi cell check

[kipper2]

I need to check the value in four differant cells. If the value in each of all four cells is greater than 1. then to complete one of two tasks based on the value.

I just what to check that the information has been entered. have been using the following will work on one cell but not any more.

Sub OUR_PRICE(Value)
If Range("F47").Value > 0 Then
If Range("F49").Value > 0 Then
Application.Run "Slip_number"
Else
Application.Run "OUR_ERROR"
End If
End Sub

Can anyone help

[NBVC]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[kipper2]

I need to check the value in four differant cells. If the value in each of all four cells is greater than 1. then to complete one of two tasks based on the value.

I just what to check that the information has been entered. have been using the following will work on one cell but not any more.

Please Login or Register  to view this content.

Can anyone help
Edit/Delete Message