difficulty with logical - if - and
On Sat, 20 Sep 2003 17:20:16 -0400, "Jean-Paul Viel"
wrote:
Hi,
If Range("b2").Value 1 And Range("b2").Value 0.0001 Then
Range("b5").Value = Range("b1").Value * Range("b2").Value
End If
Hello:
I've entered the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("b2").Value 1 And Range("b2").Value 0.0001 Then
Range("b5").Value = Range("b1").Value * Range("b2").Value
End If
End Sub
However nothing appears in cell B5
even though I entered 4 in cell B1 and 1 in cell B2 on the
spreadsheet.
Thank you, Manuel
|