Hi
I have been using some UDF to generate strings of formula that are recognizable in Excel, but not in VBA, and I want to minimize the traffic between VBA and Excel to optimize the looping speed.
Is there any ways to expand the Evaluate() function's restriction of string length not exceeding 255 characters?
Thanks in advance!
I have been using some UDF to generate strings of formula that are recognizable in Excel, but not in VBA, and I want to minimize the traffic between VBA and Excel to optimize the looping speed.
Is there any ways to expand the Evaluate() function's restriction of string length not exceeding 255 characters?
Thanks in advance!