Excel VBA - copy/paste special to another worksheet and descending rows

[TheRobster]

Hi all,

I have two worksheets in a workbook, one called Calculations and one called Results. Calculations has a bunch of equations for running some data analysis that iterates through data sets using VBA code and results from each iteration are always output in cells A1:Z1. Results from each iteration need to be stored in the worksheet called Results.

Basically I need some way of copying cells A1:Z1 from Calculations worksheet to Results but each paste operation has to be below the last, e.g.

iteration 1: copy/pastespecial values only A1:Z1 from Calculations to A1:Z1 in Results
iteration 2: copy/pastespecial values only A1:Z1 from Calculations to A2:Z2 in Results
iteration 2: copy/pastespecial values only A1:Z1 from Calculations to A3:Z3 in Results

Etc etc. This process continues for some amount of iterations that is user-defined (I have this bit sorted using a variable).

I imagine there's some combination of pastespecial and xlup commands that can do this but I've tried to write the code without success. Can anyone offer any help?

Thanks in advance.
-Rob