Cost carries across NOT down...?!?!

Hi All,

I'm getting a bit of a quirk with the following bit of code and wondered what on earth I am not getting right....

Please Login or Register  to view this content.

If I run the code with the destination cells specified as a fixed range

e.g.

Please Login or Register  to view this content.

it will run copying the data down the rows then moving across the columns as I require. However if I run it as is (and the number of rows do change!) it copies across not down which is not what I want.
Also, if I specify the range with a variable as I have in the first example I seem to be limited to only two ranges of cells. How do I make it reflect the second example (i.e. 3 lots of columns) with a dynamic row number.

Any help will be massively appreciated!

D'oh, thanks romperstomper, hugely appreciated!

Have a great week.