VBA Macro to Select range and copy paste to another sheet continuously

[Wizard23]

Hi,

I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing each range that would be great !!

I'm also new to the forum so Hello to all of you!

Best

 

[DebugGalpin]

Sheets("Sheet2").Activate

Pop that before the copy line and see what happens...

 

[Wizard23]

Sheets("Sheet2").Activate

Pop that before the copy line and see what happens...

Sheets("Sheet2").Range(Cells(Start, 1), Cells(Start + 999, 10)).Copy Sheets("Sheet2").Activate Destination:=Sheets(ws).Cells(1, 1)


So like that? I get a compile error now is that how you wanted me to write it ?

 

[Wizard23]

Sheets("Sheet2").Activate

Pop that before the copy line and see what happens...

Hey I was curious did the macro end up working on your excel ? I'm been debugging still can't find a fix. If you could help or anyone for that matter I would greatly appreciate it !!!