Method Of Range Class Failed (SOLVED) - MrExcel.com

i just figured out that when you change sheets too often in VBA and get an Activate Method Of Range Class Failed or a ... Of Range Class Failed" error, which is a run-time error 1004.

www.mrexcel.com