Posted to microsoft.public.excel.programming

Gordon[_13_] Gordon[_13_] is offline

external usenet poster

Posts: 1

Error 2015 from ConvertFormula

When the input formula gets longer than about 230 characters,
convertformula returns Error 2015. I get this response in Excel
versions 97 and 2000 with both Windows 2000 and Mac OS 9.2 (excel 98).

Has anyone run into this? Does anyone have a work around -- I wrote
the Macro because the formulas I need to manipulate can be many, many
more than 230 characters.

Gordo

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
why does excel 2007 subtract 2009 from 2015 = 1900?	Penny32	Excel Worksheet Functions	7	May 11th 09 06:19 PM
Error: "Excel encountered an error and had to remove some formatti	Carl	Excel Discussion (Misc queries)	0	September 18th 06 06:39 PM
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
How to avoid error 2015 when using ActiveCell.Offsett in own function	Torben Laursen	Excel Programming	2	February 18th 04 03:53 PM

All times are GMT +1. The time now is 08:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us