Sub CFormula()
'By: Joe Was
'Copy the formula from cell named "Formula1" to the active Cell.
Range("Formula1").Copy
ActiveCell.Select
Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub
Copy this to a module or Right click the sheet tab and select view code and paste the code from above. Close the editor and select Tools-Macros-Macro highlight this macro and press options add the Hot-Key "c" as c. Close. Then when you select a cell and press Ctrl+c the macro will copy the formula in "Formula1" to your selected cell.
To learn code, use the help function within the code editor. Help on a sheet is limited to sheet options. On the "View Code or Module" pages in the VBA Editor the help is for Visual Basic A. The help will give samples of how to use the code.
Try making recorded macros universal by changing the code that was recorded. Change "Range("A1").Select" to "ActiveCell.Select" or other ref. and play with the code to make it do more or to remove the limitations put into the code by the recorder. This should get you started.
To start: you need to name a macro, then tell the code where you are going to work, what you are going to work with, what you are going to do with your selection and how you want to end. JSW