excel 2007 UDF name problem
 

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,

excel 2007 UDF name problem
 

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