Automating Table Population
Posted by Kris Lyon on July 25, 2001 4:27 AM
I'm trying to automate filling in a table with results performed by a model. I need to insert a "1" into a cell which calculates through the model and produces a set of results. I then need to copy - paste value the results into a table. I need to repeat this 400 times starting with 1 in whole steps (1, 2, 3, etc).
I've done most of my automation with simple macros, but need help on this one to create the loop.
Can someone help?
Here's the basic procedure.
Thanks,
-Kris
Sheets("Rates & Pmts ").Select
Range("M5").Select
ActiveCell.FormulaR1C1 = "1"
Range("X7:AV7").Select
Selection.Copy
Sheets("Loan Terms Sheet").Select
Range("B6").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False