Macro to copy and paste a range of values numerous times

[peppa_chami]

Hi All,

I would like to have some help regarding the following macro. I would like to copy a range of values in a certain column and paste it down the same column 365 times, with offsetting one row. For an example;

1) Copy A2:A682 (This will always be the same)
2) Paste it in A684:A1364
3) Then in A1366:A2046

Like wise this needs to be pasted 365 times, always offsetting 1 row.

Could you please help me with a macro for this. Greatly appreciate any help.

 

[JackDanIce]

Lol no, didn't mean to pick holes and certainly wouldn't resource hog your PC!

The reason for mention is, when the code complies, it will convert an Interger type into a Long type and if anything this will increase run time, compared to the variable being declared a Long at the outset.

As we were talking about using arrays, I, perhaps mistakenly, thought you'd like to be aware of any other speed improvements or what MS VBA does in the background.

Obviously a piece of code this small it's neglible the difference, but with bigger projects, all the small gains/improvements do add up to a noticeable, improved run time.

 

[Dryver14]

I'm allowed a bit of fun...I really do appreciate the tip.

I get a nugget or 2 everyday from here....who knows, in a few years I may be able to start my PC up on my own lol

 

[JackDanIce]

Keeps the day ticking!

 

[peppa_chami]

Thanks alot JackDanIce. Greatly appreciate your help