I don't think a limitation is a bug per se, if the macro doesn't work it is
a bug in your code. However you can name parts of the formula using
insertnamedefine which in fact would make your workbook look less clunky.
e.g.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

will return the sheet name and if you use that in a formula for the sheet
name in multiple places it would make the formula long, now if you give it a
name like formula1 doing insertnamedefine then you can refer to it as

=Formula1


--

Regards,

Peo Sjoblom

"Brett" wrote in message
...
Alright, I figured out my problem, but it isn't a solution. The formulas
that are not working are over the 255 character limit. I could possible
split some up, but this would make the spreadsheet look very clunky and
confusing. Does anyone know of any way to get aroung this bug?

"Brett" wrote:

I'm in the process of making a very large macro to format a report and
identify errors. To do this, I have some gigantic array formulas, and
they
seem to be causing the macro problems. When I recorded the macro, a
pop-up
box would come up saying "Unable to Record" when I ctrl+shift+entered
the
formula (the formula does work when not trying to record macro). Now,
when I
try to run the macro it bombs my system. Is there a size limitation for
array formulas in macros? Any suggestions?