I have a formula that is 300+ characters, too long to insert as an Array Function with VBA. It cannot be broken up
Here is the script:
I have read there are two solutions to the problem: breaking up the formula, and or having code which types in the CTRL+SHIFT+ENTER to transform the equation into an array after it's dropped in a cel.
Please Login or Register to view this content.
Which method would be better, and how do I apply it to this situation?
Not sure if this will help or not, but you dont need to use double "", you can just use...
=IF(ISBLANK(D4),"",.........etc
this will take a bunch of unnecessary characters from that
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
deleted my triplicate post
Last edited by FDibbins; 02-09-2016 at 12:32 AM.
deleted my triplicate post
(you could say that, Trevor lol)
Last edited by FDibbins; 02-09-2016 at 12:32 AM.
Bit of an echo there Ford ...
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The """" seems necessary for inserting formula, I get run-time errors if they're not in the equation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks