Help with Copying Ranges and Offsets

I have a spreadsheet where I want to copy data from one sheet to another. The range to be copied is dependent on a few variables. It will always be 55 rows long and 'j' columns wide. Variable j represents the variable that will change every time this macro is run. I'm having issues when I try to activate the range to be copied. I get an application error or a with block error depending on whether the with block is int he code. I saw this on another website which had me insert the with block: http://stackoverflow.com/questions/1...d-error-in-vba
It's been a while since I've coded and I am very rusty. Anyways, here is my code below. I feel like if I can get past this copying the range part and understanding my errors using offset, I can easily finish up what I want it to do - which is why my code will appear to be useless (I haven't finished the rest of it yet). So thanks in advance!

Please Login or Register  to view this content.

Thanks for the response.

I see what you mean by the range. Confused me at first. How do I assign a value from a cell without defining it as a range? My intentions are to keep noStreams as an integer as declared.

I want to copy a range that is 55 rows down from the active cell and "noStreams" columns wide.

You aren't really using the with.

Give this a try, I've added dot qualifiers to tie the ranges to the worksheets in the Withs.

Please Login or Register  to view this content.

The active cell in your code is E5, so instead of using ActiveCell I used Range("E5").

If you want the range to change use a range variable, set it to E5 at the start then offset it on each iteration of the loop.

Please Login or Register  to view this content.