I need to pickup the sheetname for the formula below in cell A1 of a sheet called LookUps.
Can anyone help? I've tried using indirect but cannot get it to work.
HTML:
Range("J2").Select
ActiveCell.FormulaR1C1 = _
"=SUMIFS(Plan!C[-5],Plan!C[-9],RC[-2],Plan!C[-8],RC[-1])"
Can anyone help? I've tried using indirect but cannot get it to work.