On Monday, November 18, 2019 at 6:57:22 PM UTC-6, GS wrote:
For years all macros I wrote for Excel were in XLM code. Trying to learn VBA
and would like to know if there is a VBA equivalent to the "=STEP()"
statement in XLM, which is very useful in debugging.

Can someone please indicate what the corresponding code is for VBA? Many
thanks.

Unable to find any reference resources for XLM Step(); - can you point or OR
explain what it does?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

It's a macro function for Excel 4.0 (yes, really old!)

As described in the manual:

"Stops the normal flow of a macro and calculates it one cell at a time. Running a macro one cell at a time is called single-stepping and is very useful when you are debugging a macro."

At each step it gives user the option to continue stepping, or running the rest of the macro normally, without interruption.

Hopefully this describes it. I appreciate your help, Garry.