Hi ,
I am trying to evaluate a sumproduct in VBA and it is acting very oddly.
The code i am trying to evaluate is:
either of the following two formulas works:
Please Login or Register to view this content.
However the first one give me a type-mismatch error.Please Login or Register to view this content.
Does anyone know why please?
p.s. dType, dStage, dCategory, are all named ranges in the workbook (all same size).
pRole, pStage, etc are all variables which are defined earlier
It would help if we knew the values of the variables were but Evaluate will only work with strings up to 255 chars in length - I suspect your first formula exceeds that length once the variables are in place.
To check -- add a Debug.Print prior to the Evaluate to see the final formula as it will be executed (Immediate Window)
(use LEN etc to ascertain length thereof)Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks