Sorry Tony ; if Anne can xfer my score to TSG & wipe it from here, that'll be fine. Check this link if you dare http://jongy.tripod.com/History.html#billy
What I wanted was to lay down several conditions (correct sheet must be active AND row must be > 2 AND column must be E or F AND cell mustn't be blank), without getting into ?-a-dozen If ... Then ... ElseIf loops.
Aside ; logically you'd think you oughta be able to say
If X Or If Y Or If Z Then
Do something
Else
Do something else ; guess not. :no
I couldn't get Select Case to check multiple lines before the Exit Sub, in the end it (?surprisingly?) played ball with
Select Case True
Case ActiveSheet.Name <> "Orders", ActiveCell = "", ActiveCell.Row < 3, _
ActiveCell.Column < 5, ActiveCell.Column > 6
MsgBox "Active cell is outside required range."
Exit Sub
Case Else
frmQuote.MultiPage1.Value = 2
frmQuote.Show
End Select
Which is pretty cool :cool (maybe I discovered something by accident?)
Thanks for the help, guys.
Rgds,
Andy