Thanks for believing me Mark. I agree that recorded macro's are inflexible -
I generally only use them to make Excel give me a statement that'll work
which I then paste into my programmed macro and modify to work there.

In this case the macro is for use on many input sheets by several users. The
input sheet/book is a variable in the general program.

Thanks again for taking an interest - it's good to know I'm not the only one
who's hit a problem like this!

"Mark Lincoln" wrote:

I believe you, John. I've been using Excel and other apps long enough
to know that strange things happen. I've seen a couple of threads
similar to yours in the Excel groups. Heck, I started one myself!

One thing that occurs to me is that you mention recording macros.
Recorded macros are rather inflexible and that may be part of the
problem, especially if you're subsequently running them from a separate
workbook. Is there any reason you couldn't keep the macro in the
'data' book?

The good thing is that you found a workaround. That's what I like
about Excel: It may put up a fight, but there's usually some way of
making it do what you need.