Hello all,
I need to populate a range with a very long formula.
It's length exceeds the 255 character limit.
Does any of you know a way to circumvent it.
This is what I have, but what doesn't work because of the length.
Please Login or Register to view this content.
Extraneous paren:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Why not just make that a regular formula, and if needed, use the macro to then copy it down?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Same error shg!
Thought about that FDibbins, but hoped for a better solution.
The formula installed fine for me. I have no idea what it's supposed to do.
You do realize I changed the formula? Code can enter formulas longer than 255 characters, just not array formulas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks