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