T2Net
=IF(OR(Condition1,Condition2,Condition3....),DoThi s,ElseDoThis)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web:
www.nickhodge.co.uk
"T2net" wrote in message
...
Do you know a way to include several conditions to one IFstep in VBA,
ie
If condition1 OR condition2 OR condition3 then action1
without using my current unelegant and heavy:
If condition1 then action1
If condition 2 then action1
If condition 3 then action1
I am sure the trick is easy..so easy that I cannot find it!
Thanks in advance for your help,
T2net