Enter a formula string in Excel VBA (division)
Posted on 2014-01-16
I need to enter a formula into K71 as a string. The formula is as follows:
Range("J71") / Range("$B$6").
I got no idea how this works in Excel VBA.
Could somebody please help me with this?
Thank you very much in advance.
strFormula = formula string?
ActiveWorkbook.Sheets("Evaluation").Range("K71").Formula = strFormula