Method Of Range Class Failed (SOLVED)

[Elemental]

i just figured out that when you change sheets too often in VBA and get an "Activate Method Of Range Class Failed" or a "Select Method Of Range Class Failed" etc, simply retype the sheets command before it

for example :

Sheets("Work1").Select
Range("A1:D50").Select

OR

Sheets(Work1").Range("A1:D50").Select

this code in VBA, if used too often or the mentioned sheet is not the currently selected sheet in a Sub, will cause errors, and to correct this, simply type

Sheets("Work1").Select
Sheets("Work1").Range("A1:D50").Select

this makes sure that the sheet is selected before running any other range/sheet type commands.

I hope this clears up some other ppl's problems, it had me for a few weeks.

 

[byrne2310]

I had the same problem with errors when running:

.CopyPicture Appearance:=xlPrinter, Format:=xlPicture

I tried ALL of the posted solutions ... no joy!
My problem turned out to be unique,but very simple to fix.

It turned out that our network printers “went south” lastnight, and it surprised me that without a network printer to act as a “target”this command would not work. I figured thatout by process of elimination, one step of which was to remove the Appearance:=xlPrinterparameter. When that WORKED it finallydawned on me that the lack of a valid printer could cause the error. Once a valid printer was networked/configured, and Excel wasrestarted to recognize it, my original code worked again.

Hope that this might help someone else with the same problemand cause!