Hi,
I have not been able to solve this. Does anyone know if it is possible to Evaluate a named range array operation into a VBA array. I can only populate the first value of the array operation.
Please Login or Register to view this content.Please Login or Register to view this content.
It is possible but you must use additional function to force array return:
for example.Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
AMAZING! Do you know why that is by any chance? What am I not understanding syntax wise? Seriously though Good Stuff!
If you do not include a function that may naturally return an array, only one value will be returned by Evaluate. Same may occur if you use formula in the worksheet and do not array enter it.
True. I just don't understand why I can't evaluate the formula, without Index.Originally Posted by Izandol
There is no equivalent for Ctrl+Shift+Enter with Evaluate so you must use a function like INDEX.
That makes sense man! Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks