-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
error 2015
-
V
Error 2015, but if I try the formula in my worksheet it returns a value
This code is giving me error 2015 togGle = Evaluate("=RIGHT(addMe.Offset(0, 17).value,6)") Despite returning a value for the offset value: Also doing the Right formula in the worksheet on the same cell returns a value.- vbaNumpty
- Thread
- error 2015 vba
- Replies: 5
- Forum: Excel Questions
-
Using Sumproduct in VBA
I am struggling with this - i think my text string is correct and when copying it to a cell to test, works okay, but I get error 2015 in VBA. I can't use sumif as the numbers are entered as text on the workbook. prop.Offset(0, 2).Value = Application.Evaluate("=SumProduct((" & _...- George J
- Thread
- error 2015 sumproduct vba
- Replies: 27
- Forum: Excel Questions
-
J
String variables in vba 2010 truncated to 251 characters
Hi... I have read that in old Excel versions (97, 2000) when working with string variables in vba there is a character limit of 255, but also read that Excel 2010 should not have that limitation... I am trying to pass a function in a string variable to an Evaluate method, and I am getting error...- jprealini
- Thread
- array formula function array formula if error 2015 string vba & excel 2010
- Replies: 2
- Forum: Excel Questions
