I have the following formula and would like to include it in a macro. I managed to include the first formula in my macro using double double-quotes but I couldn't figure out a way to include the second formula which is simply an extended IF/THEN/ELSE statement. 

=IF(COUNTIF(G4, "*SBR*")=1, "SBR", IF(COUNTIF(G4, "*XX*")=1, "Strategic", IF(COUNTIF(G4, "*FB*")=1, "Strategic", IF(COUNTIF(G4, "*-???*")=1, "Program Enrollment", "No Match"))))
=IF(COUNTIF(G4, "*SBR*")=1, "SBR", IF(COUNTIF(G4, "*XX*")=1, "Strategic", IF(COUNTIF(G4, "*FB*")=1, "Strategic", IF(COUNTIF(G4, "*-???*")=1, "Program Enrollment", F(COUNTIF(G4, "*P.E.*")=1, "Program Enrollment", "No Match")))))
Thanks!!

GC