View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
billabong billabong is offline
external usenet poster
 
Posts: 14
Default 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