Excel behaves differently during macro record.

[Jim Luedke]

I have an Excel 2002 worksheet. Calc is auto.

Almost all my cells are calls to a couple of functions I wrote (I
presume they're called UDFs).

On the menu, when I execute:

- Insert / Rows

Excel inserts a blank row. Great. But when I execute:

- Tools / Macro / Record New Macro / <Get new-macro dialog and press
Enter to continue> / Insert / Rows

the blank row inserts, but *bang*, all cells immediately revert to
"#NAME".

Now, I've had at least 3 flavors of the problem:

- After everything turns to #NAME, getting the values to revive
requires me to go thru every cell and edit/exit to force calc.

- But sometimes, after ditto, editing/exiting just *one* cell brings
everyone to life again. I can live with that.

- Or, best (but from an understanding-the-problem standpoint, worst),
now the symptom is no longer happening, and I'm unable to repeat the
problem.

I suspect it all relates to my separate question about why Excel fails
to update all UDF calls (but worst of all seems to have no way for you
to *manually* force all UDFs to recalc). (I apologize to anyone not
using Google

http://groups.google.com/group/micr...read/thread/65831b37cdf3ef91/fe942b1e76d8af64

Anyway, back on topic: Macro recording is transparent. It should
record what you're doing, not *change* what you're doing.

I mean, huh?

Thanks.

***

 

[Dave Peterson]

Did that last suggestion (in your previous thread) work when you tried it?

And can you shrink your UDF down to just the important parts and post that
function. It could be lots easier to diagnose any problem if the code was
available.