Hi,
could anyone tell me how to convert a formula =If And... onto a macro
Regard

--
herv
-----------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...fo&userid=2731
View this thread: http://www.excelforum.com/showthread.php?threadid=54993

Sorry if I completely misunderstand the question, but are you lookin
for some VBA code as basic as:


Code
-------------------
Sub IfSomething()
If <condition01 AND <condition02 Then
<do something
Else
<do something else
End If
End Su
-------------------



--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=54993