danbrawl93
New Member
- Joined
- Dec 15, 2016
- Messages
- 17
Hello!
I am struggling to use the following nested function (written as if it was in a cell) in VBA:
=Iserror(Search("Hello",A1,1))
Essentially, I want the formula to produce FALSE if the cell contains the word "Hello" (there may be other words). This would be in a dynamic loop and the VBA I have tried is...
For n = z To y
If Evaluate("Iserror(search(""Hello"", cells(n,1), 1))") = True Then
Do stuff and end loop etc.
I have tried using WorksheetFunction but to no avail. I also cannot get the following to work, so I think the issue lies with how I am nesting the functions?
Range("A3").Value = Evaluate("sum(""I4:I6"",product(""K4:K6""))")
Please help, both with general syntax and the code highlighted in bold text!
Thanks
I am struggling to use the following nested function (written as if it was in a cell) in VBA:
=Iserror(Search("Hello",A1,1))
Essentially, I want the formula to produce FALSE if the cell contains the word "Hello" (there may be other words). This would be in a dynamic loop and the VBA I have tried is...
For n = z To y
If Evaluate("Iserror(search(""Hello"", cells(n,1), 1))") = True Then
Do stuff and end loop etc.
I have tried using WorksheetFunction but to no avail. I also cannot get the following to work, so I think the issue lies with how I am nesting the functions?
Range("A3").Value = Evaluate("sum(""I4:I6"",product(""K4:K6""))")
Please help, both with general syntax and the code highlighted in bold text!
Thanks