Code not working - copy and paste.

[RandomPezzer]

Hi Guys,

I'm trying to copy data from one sheet to another sheet but keeps coming up with End or Debug.

I want it to copy the data from Sheet Data Range A2 and E2 down to the last cell with a value in it. then copy to sheet 0209 and paste in A6

I'm looking to avoid using the clipboard to copy and paste.

Code I have:

Please Login or Register  to view this content.

Any help would be appreciated

Thanks

[judgeh59]

I believe your Range parameters need to be separated by a colon ":" not a comma ","....I believe

[mrice]

Maybe

Please Login or Register  to view this content.

[RandomPezzer]

If i separate them by ':' it will copy columns A2 to E2 all i'm after is Column A2 and E2 thats why i thought a ',' would work.

[AB33]

Amended following update

Please Login or Register  to view this content.

[judgeh59]

Looks like mrice's code should work if you change the his colons to comma's...

[RandomPezzer]

Just tried that and I get

Run-Time error '9':

Subscript out of range

End | Debug.

tried with the : and with the ,

[AB33]

Did you try my code?
Error 9 means one of the sheets names is wrong. You need to check the sheet names exist on the workbook you are working.