Anyone know why this won't work? Can I not mix R1c1 with a direct cell
reference like B1? And if not, How do I replace $B$3 with something in r1c1
format? Thanks!


Set colb = ActiveCell.Offset(0, -2)
colb.FormulaR1C1 = "=IF(RC[-1]=""Open"",MAX($B$3:R[-1]C[-2])+1,"""")"