| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: UDF can't reference row below 65536
In Excel 2007 (I'm on SP2), if I enter this formula:
=SUM(A65537) It works fine. But if I enter this formula: =MYUDF(A65537) Excel turns it into this: =MYUDF(#REF!) That isn't the UDF's fault' Excel is doing that before the UDF has the opportunity to do anything at all. Is there a workaround or fix? Thanks, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - ADO - More than 65536 rows - Problem ? | Excel Programming | |||
| How do I get my Excel 2007 worksheet to go beyond 65536 rows? | Excel Worksheet Functions | |||
| Excel 2007 - ADO - More than 65536 rows - Problem ? | Excel Programming | |||
| Why Excel 2007 still have the 65536 raw limit? | Excel Discussion (Misc queries) | |||
| Excel 2007 65536 rows-convert | Excel Discussion (Misc queries) | |||
Threaded Mode
