Debugging Error (2007 vs 2010)

Good afternoon,

I have a macro (written using 2007) with the following code

Please Login or Register  to view this content.

When the macro is run in Excel 2010 we get a Run-time error '438': Object doesnt support this object or method

Not sure how to fix this so any help would be greatly appreciated.

I should add the the ClearHeader macro is being called another macro