Data gathering: Iterations with range data problem

[rayray2013]

Hi,

I am using the following code to copy each iteration of the range I11:I792 in worksheet "sim" next to each
other into worksheet "sim2". Iterations are defined in worksheet "sim" A1. I have no problem to copy individials
cells, however I struggle to modify the code to work with iterations in ranges.

here is the faulty code that I use, the debugger says something is wrong with the .cells commands. I actually
searched the forum for two days to figure out the code, and it worked, however I am not able to do the modifications
needed in order to work with ranges. I have no other idea than to define the range via cells as I did it.

Please Login or Register  to view this content.

The range that I copy consists of value calculated via rand(), which is reason why I need the iteration.
The code actually gathers several iterations of a calculated dataset for a chart.

I really hope that someone can help me.

[rayray2013]

I checked the Range definition via cells again and I can't find any error, so I really wonder why it doesn't work. Any ideas? I need to get a simulation done and just can't figure it out.