I have this formula that I the compiler does not like:
Worksheets("Pre").Range(wraps.Address).Offset(0,-3).Formula = "=if(" & B1 & wraps.row& "*" & B2 & wraps.Row& * & B3 & wraps.Row& * & B4 & wraps.row& * & B5 & wraps.Row& ",1,0)"
The compiler is highlighting "*" in yellow. I am pretty sure that I have the variables all defined correctly.
I am just trying to multiply.