Most valuable professional
  • Hot Topics

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 Code: 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 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel