IF Activecell.Value = "TYP 450" Or _
Activecell.Value = "TYP 490" Or _
Activecell.Value = "TYP 350" Then

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alastair79" wrote in message
...
As part of my code I need to ask what the active cell contains, it will
always be text and one of three options (TYP 450, TYP 490, TYP 350)

IF Activecell = "TYP 450" then

Something along these lines. what would the actual code be.

Thanks...... Alastair.