On a side note:

I can't believe you don't use Option Explicit in all your code.



In VBE Tools | Options

Check the box for force variable declaration.

This is a perfect example of why Option Explicit is a must use command. With Option Explicit instead of the generic Object Required error you get a much better error.

It will in fact highlight ActiveWorkSheet and state Variable Not Defined. So you know that you have made up your own variable and not refered to a named object as you wanted to.