'HOW TO RUN EXCEL FORMULA USING VBA'
Option Explicit
Sub Function_BY_VBA()
In sheet2 Range c2 Formula will be placed
Sheets("SHEET1").Range("C2").Select
''' ActiveCell.FormulaR1C1 ="YOUR EXCEL FORMULA"
ActiveCell.FormulaR1C1 = "=IF(RC[-2]>=60,""A grade"",""B gra
I need this formula within the VB code on "Over Flow Report", Column
"D". =IF(C3="","",B3*C3). I'm trying to understand how it works. Is
this correct? Do I need to add anything?, Should it go in the
worksheet_change or worksheet_select_change?
Worksheets("Over Flow Report").Range("D3").Formula =
"=
