Determine if the macro has been executed

[mrroland]

Hi,

I have the following piece of code

    'format both BBS files
    wbThisMonth.Activate
    FormatBBS
    wbLastMonth.Activate
    FormatBBS

Nothing spectacular but the second time it calls the FormatBBS macro it needs to skip a certain piece of code of that macro. Can anyone advise me how to go about that?

The macro that calls the FormatBBS macro is in the same module. I would like to do it with an array but i never really have understood how they work

Cheers,
Roland

 

[jim may]

You could use a boolean variable flag type dowitchy...
setting it from a default of False to MyFlg = True

 

[VoG]

One way:

At the top of your module, outside any subs

Dim Already As Boolean

Then inside your sub just before you exit:

Already = True

and within your code something like

If Not Already Then
'
'do the stuff for the first call only
'
End If

 

[mrroland]

Thanks VoG,

That was exactly the solution.

So very possible without an array

Thanks again, learned something new

Cheers,
Roland