Jaimie,

I wasn't suggesting it as a workaround, for the reasons you mentioned. I
just thought it was worth mentioning - especially since I had nothing else
to offer <g.

Doug

"Backslider" wrote in message
oups.com...

Doug Glancy wrote:
Backslider,

I've spent half an hour looking at this. I can reproduce the problem (XL
03) but I can't figure out the cause.

I notice that if I drag the fill handle using the mouse, it works fine,
but
when I copy and paste, it fails as you describe.

Good luck.

Doug,

Thanks for looking into it.

This is a simplified example of what happens in our commercial
application (using VSTO 2003), so the "drag" workaround isn't going to
work. I don't think it is feasible to tell the customers that they
can't copy/paste.

If I could come up with some kind of code workaround to get Excel out
of whatever state it is in that it doesn't let you put the UDF into a
cell, that would be viable.

Jaimie