run time error but code looks right?! please double-check me

[fredderf81]

I am stumped on this one! All i am trying to do is select a row on one sheet, the entire row, and copy it do a row on a different sheet and i am receiving a run time error 1004 Select Method of Range class failed. the code is in an activex button. here is the code

Please Login or Register  to view this content.

any ideas??

[tuongtu3]

Make sure you have a sheet name "one"
Regards,
tt3

[fredderf81]

i'm still stumped...sheet names were the first thing i looked at.

[Norie]

Don't use Select.

Please Login or Register  to view this content.

[fredderf81]

i got it!!! ....had yet another light-bulb moment...hope this helps if anyone needs it:

Please Login or Register  to view this content.

[fredderf81]

EDIT: just say Norie's post as well! that worked too!! thank you much for the help again! =)

[Norie]

My code is the same as your code, except I'm lazy and didn't include the named argument Destination.