quick Q

[abz2max]

how can u wirte a macro that says that if x is not 2 or 4 or 8 then exit macro

 

[Mark O'Brien]

Something like this.

<pre>

Select Case x

Case 2 or 4 or 8
yourmacro

Case Else
'Choose 1
'Exit Sub
'Stop
End Select</pre>

HTH