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("J1").Copy
    Range("J2:J" & LastRow).Select
    ActiveSheet.Paste
    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