I insalled the Office 2007 from MSDN subscription, and find a strange
behavior that doesn't occur at Office 2003.

If I define a User Defined Function (by VB macro) with name like 'qAB01',
wherever I typed "=qAB01()' in a formula bar for a cell, the formula will be
auto-changed to "=QAB1()". This results in a #REF error.

Addtionally, I find that I can not register a UDF with name 'qAB01' too
through XLL C API too.

Thanks,

xl2007 has 16384 columns, right?

What's the address (in A1 reference style) for the rightmost cell in row 1?

I'm guessing that QAB01 looks too much like a cell address in xl2007.

Terry Zhang wrote:

I insalled the Office 2007 from MSDN subscription, and find a strange
behavior that doesn't occur at Office 2003.

If I define a User Defined Function (by VB macro) with name like 'qAB01',
wherever I typed "=qAB01()' in a formula bar for a cell, the formula will be
auto-changed to "=QAB1()". This results in a #REF error.

Addtionally, I find that I can not register a UDF with name 'qAB01' too
through XLL C API too.

Thanks,

--

Dave Peterson