Copy multiple batches of data using VBA

I do not know what is the purpose of

YouLikeToPasteTo = "A1"

With .Range(YouLikeToPasteTo)

Means you are copying the selected range in A1.
You are also copying 2 rows 1 (A1:C2 ) Only.

I do not know what are trying to do, but a simplified version of your code.

Please Login or Register  to view this content.

Your post contradicts your example workbook. In your post you say Range "E1" but in your workbook E1 is blank. You show J1 in your code, but J1 is blank. I will assume that you meant Sheet1 Range F1.

Please Login or Register  to view this content.

Edit: Darn it AB33, beat me again

That's perfect thanks I got it working with

Please Login or Register  to view this content.

Originally Posted by stnkynts

Your post contradicts your example workbook. In your post you say Range "E1" but in your workbook E1 is blank. You show J1 in your code, but J1 is blank. I will assume that you meant Sheet1 Range F1.

Please Login or Register  to view this content.

Edit: Darn it AB33, beat me again

Sorry think I may have accidentally attached the wrong workbook! Sorted now though thanks anyway.

stnkynts,
Nowadays, I am trying to play as poacher, not a mid-fielder,despite a football game is lost and won on midfield.