View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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