Thread: Question on VBA
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you can call another sub. Just insert it instead of exit sub

--
Regards
Frank Kabel
Frankfurt, Germany

"Jeff" schrieb im Newsbeitrag
...
Hi,

This is a partial copy of my VBA macro. My question is: Is possible

in VBA
to execute a sub in an " If ... then statement?"

If TopCell Is Nothing Then
MsgBox myStr(iCtr) & " wasn't found"
Exit Sub --- here can I request the execution of sub

instead of
Exit sub?
Else
.Range(TopCell, BotCell).Select
End If
Next iCtr
End With
Thanks,