Hi,

this is my first post and I don't know anything about macros except how to record one in excel 2007. I’ve created a model with several inputs that a user can change in the tab called analysis. I’ve also created a list of several permutations of those parameters starting at CF6. My goal is to write a macro which simply inputs those permutations into the model and pastes the resulting outputs next to the corresponding parameters. I've recorded the macro as I want it, but can't figure out how to loop it to go down the entire column. The recorded code is as follows:
Sub Test()
'
' Test Macro
'
' Keyboard Shortcut: Ctrl+t
'
Range("E25").Select
ActiveCell.FormulaR1C1 = "=R[-19]C[82]"
Range("E27").Select
ActiveCell.FormulaR1C1 = "=R[-21]C[83]"
Range("E33").Select
ActiveCell.FormulaR1C1 = "=R[-27]C[84]"
Range("E34").Select
ActiveCell.FormulaR1C1 = "=R[-28]C[85]"
Range("Q30").Select
Selection.Copy
Range("CM6").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Selection.NumberFormat = "$#,##0.00"
End Sub

Please help me! Thanks!