Hi Laserface,

Try:

If Sheet5.Cells(6, 11) 40 And _
Sheet5.Cells(6, 11) < 300 Then

---
Regards,
Norman



"laserface " wrote in message
...
Sorry, this is probably a daft question but its driving me nuts.

I want to write a routine where a picture becomes visible or not
depending on the magnitude of a number in a particular cell.

The following works ok on a single greater than condition
The image being contained in an image control obviously.

If Sheet5.Cells(6, 11) 40 Then
Sheet5.Image1.Visible = True
Else
Sheet5.Image1.Visible = False
End If

However i want to use the "OR" function to make the picture visible if
the magnitude of a number in a particular cell falls between a
particular range so i think the code should be something like


If Sheet5.Cells(6, 11) 40 or < 300 Then
Sheet5.Image1.Visible = True
Else
Sheet5.Image1.Visible = False
End If


But the line 40 or < 300 does not work and i cant figure out why.

Any and all suggestions greatfully recieved !

regards
LaserFace


---
Message posted from http://www.ExcelForum.com/