Select Case VarType(Application.Evaluate(vCommandFinal)) Case vbObject Set vResult = Application.Evaluate(vCommandFinal) getEvaluateFormula = vResult(rowContext(vResult.Worksheet.Index)) Case vbError Stop vResult = "Unknown or Invalid" Case Else Set vResult = Application.Evaluate(vCommandFinal) Debug.Print VarType(vResult) getEvaluateFormula = vResult End Select
|Match formula returns N/A||5||25|
|Vb.net dynamic formulas in runtime||11||62|
|How to change the following 2nd comma in each line to a tilde (~) in Excel 2016?||6||44|
|Steps to program a particular database app using access and any programming language.||16||37|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!