Unable To Record Macro

[Satch7]

Hi,

I am working on a S/S which I have already added lots of macros in.

Tried to record a new macro and a message "unable to record" appears.

Then get an error message from Excel which then shuts down.

Anyone else ever encountered this?

 

[Peter_SSs]

Is this the problem?
http://support.microsoft.com/kb/212172/en-us

 

[Redrazorneck1]

Satch - I am having the same problem with a macro I'm trying to record. Thanks to Peter's link to the Microsoft support web site, I now know what the issue is (thanks, Peter!).

I have a problem with Microsoft's solution - simply don't record a macro in which you are entering more than 255 characters within a cell. I hope this issue is resolved in Excel 2007!

I resolved my issue by breaking up the formula into several columns for the purpose of the macro. While the columns serve no purpose other than flags or control mechanisms for my 'IF' statements, I can easily hide these columns within the program of the macro.

If there are other ways around this problem, I'd like to hear them as well.

 

[Gold_fingers_95]

Hello everyone,
This issue is driving me crazy! I'm having a similar "out of memory" and "unable to record" though, I haven't any cell exceeding 255 characters in the file.
here is the file (if this can help)...
Thank you in advance