I have a written a Vb macro to copy a formula with variable NAME elements but don't know how to use the F2 key in conjunction with the F9 key followed by enter to convert a concatenated text string to a formula. See below:
Code:
Cell E38 '=IF(I42="S";IF(VALUE((+B42-(INDEX( Cell E39 'Barclays Cell E40 ';COUNTIF(INDEX( Cell E41 ';0;8);"<0");2)))/365)>3;"C";"R");"")