I need a VBA for Excel function that will concatenate a static string and additional the values from other cells and insert the new string as an active DDE formula into an adjacent cell. NOTE: I currently have the formula for the concatenate function working. Also, I have another function working to complete my needs except that the DDE link is not active. The above specifications would be acceptable, but ideally, I would like to have a macro or additional VBA code to populate adjacent cells with other formulas.