evaluate string vba code

So this is a simplified version of a problem I am having in a much larger VBA macro. Essentially I need to perform the following worksheet calculations in VBA: =STDEV.S(IF(A1:A100 = "a",B1:B100)) =STDEV.S(IF((A1:A100 = "a")+(A1:A100 = "c")+(A1:A100 = "e")+(A1:A100 = "h")+(A1:A100 =...

I have a couple of macros that have been running weekly for over 2 years. However, the first time they have been run this year the EVALUATE line crashes in the following piece of code: Dim deleteStudent As Boolean deleteStudent = Evaluate("IsError('Student Data'!1:1)") If...

I am trying to evaluate a formula with this code Sub test() Dim myRange As Range Set myRange = Worksheets("Sheet1").Range("A1:B10") 'answer = Application.WorksheetFunction.Max(myRange) answer = [SUMPRODUCT((LEN(myRange)>0)*1)] MsgBox answer End Sub But I getting an error...

Hi all. I have a dilemma I hope you can help me with. I am not great at VBA so bare with me. I need a macro that will look in an individual cell and work out what to do with its contents. There could be a number, or a text and a number. the column is essentially serial numbers. for eg. item 123...

Dear all, it's late at night where I am and my brain is not working anymore (if it ever was): I want to build and evaluate a VBA expression by reading in a string with a VBA expression from a spreadsheet cell. The purpose is to match up tags based on recognized patterns. Given a tag pattern is...