-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Unable To Record Macro
- Thread starter Satch7
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
Is this the problem?
http://support.microsoft.com/kb/212172/en-us
http://support.microsoft.com/kb/212172/en-us
Upvote
0
Redrazorneck1
New Member
- Joined
- Aug 10, 2005
- Messages
- 6
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.
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.
Upvote
0
Similar threads
- Question
