How to paste to a larger range

Hi,

How do I copy a range named SourceFormulas (located on sheet1, A10:B10) down to a row on the same sheet and same columns where the row to copy to is a number in a named range and the size of the paste range down is in another named range?

For example, I want to copy SourceFormuals to row number StartFormulas (which holds the value 500) and make the size of the paste area down RecordCount (which holds the value 10). So, copy A10:B10 to A500:B500 and have it extend (resize?) down to A509:B509.

I posted a similar question here some time back, but my explanation was way too complicated and I never got it solved. Hoping it's a simple macro that uses my named ranges.

Thanks!

Lawrence


Original post:
http://www.excelforum.com/excel-prog...fied-rows.html