I have recorded a macro to calculate a sheet (f9), copy a cell, paste that cell value, then copy a range of cells, paste the cell values. The copied cell that changes value with each calculation [based upon NORM.INV(RAND)] is pasted in a single column one row lower each time. The copied range of cells also changes with each calculation and that range is pasted in a columns that move sequentially to the right. The values in the columns are used to create a line chart in the spread sheet. I've recorded a macro that does what I want, but I only recorded it for 6 iterations. I'd like 100 iterations. Also, I need the view to remain on the chart during the calculations, since watching the line plots real time adds to the impact of the chart. Currently, the focus of the spreadsheet moves to the area of the pasted values, then returns to the chart area based upon my final cell selection. The attachment shows only the first three calculate, copy, paste operations.