Copy method of range class failed

Q

quiksilver

Hello,

when I try to run my macro I have recorded before I get message "Copy
method of range class failed"; it is just simple
Range("B1:B10").Select
Selection.Copy
Anybody has idea on this bug ?

Thanks a lot


PS I have ibook G4 933, office 2004
 
J

JE McGimpsey

quiksilver said:
Hello,

when I try to run my macro I have recorded before I get message "Copy
method of range class failed"; it is just simple
Range("B1:B10").Select
Selection.Copy
Anybody has idea on this bug ?

Thanks a lot


PS I have ibook G4 933, office 2004
Click to expand...

Have you updated Office 2004? This was a frequent problem before the SP1
update.

BTW. You almost never need to select anything. Your

Range("B1:B10").Select
Selection.Copy

is more efficient, shorter, and easier to maintain (IMO) as

Range("B1:B10").Copy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select method failed - Error 400 2
how to get a simple macro to paste value 4
VBA for Dependents shortcut menu 0
Run-time error when copying entire row! 5
" Select method of range class failed" if sheet not on top 4
Help with this code please !!!!!!! 4
CopyPicture method of range class failed using RangeName 5
macro method of range class failed error 4

Top