Excel: Create a vba formula from cells

Need a little assistance with a vba formula to get info from cells to create a formula like this

    Range("J1").Formula = "=IF(D1=""Mayberry R.F.D."",""Mayberry RFD""," & _
    "IF(D1=""Diners, Drive-ins and Dives"",""Diners Drive-Ins and Dives"",IF(D1=""Forever "",""Forever (2014)""," & _
    "IF(D1=""Food Factory (CA)"",""Food Factory CA"",IF(D1=""Castle (2009)"",""Castle 2009"",IF(D1=""Guy's Grocery Games"",""Guys Grocery Games"",D1))))))"
    Range("J2:J" & LastRow).Select
    Application.CutCopyMode = False
I am constantly adding to the formula. So, say column A would be what to look for, column B what to change to to. Thanks

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of May 26, 2015.

For more resources for Microsoft Excel