Excel 2007: UDF can't reference row below 65536
On Wed, 12 May 2010 07:24:46 -0700 (PDT), Greg Lovern wrote:
When I got home last night, I tried it again, to work on a workaround
until I have a chance to find and fix the bug. To my surprise, it did
NOT repro on my home computer! When I got back here this morning, I
verified that it does repro here.
On both computers, I'm running Excel 2007 SP2, and I was using the
same version of my add-in, with the xla and dll both installed by the
same release package. To repro the problem, in both cases I was using
the same sample .xlsx file.
I have no idea why it works on one computer and not the other.
Greg
Try saving the file as an .xlsm file.
--ron
|