Hello, what might be wrong with this code?
If I copy "mysum" contents to a cell and replace "lista" with a defined list, it works just fine.
But whenever I run this code, it gives me syntax error.
Please Login or Register to view this content.
Hello, what might be wrong with this code?
If I copy "mysum" contents to a cell and replace "lista" with a defined list, it works just fine.
But whenever I run this code, it gives me syntax error.
Please Login or Register to view this content.
Last edited by chiidzzz; 07-28-2013 at 05:04 PM.
I see that your MATCH has the value begin sought argument swapped with the range being searched. Try
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
I still get syntax error
Try running
to see if there are misplaced parenthesis etc.Please Login or Register to view this content.
Also, lista is a variant. Evaluate will not accept a variant array as an argument for MATCH. You might substitute Sheet2.Range(ActiveSheet.Range("D6").Value).Address for lista in the formula.
Last edited by mikerickson; 07-28-2013 at 02:43 PM.
it works fine with activeCell.Formula ....
The error returned is 2015. Something related to 255 characters limitations which I can't understand.
Last edited by chiidzzz; 07-28-2013 at 04:34 PM.
So why do you use with...End with without referring to this object once ?
Do you know what With...End With means ?
Sorry it was by accident, I removed it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks