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 :
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
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.