VBA columns thorowing "wrong number of arguments or invalid property assignment" error

So I'm just trying to do a quick formatting macro, Iused the macro recorder and upon trying to play it back it broke! Hrumph.

Please Login or Register  to view this content.

(and many commands like it) throw an error (wrong number of arguments or invalid property assignment)

The macro name is NOT columns or anything else that might be protected.

This version throws the same errors.

Please Login or Register  to view this content.

edit: I found a workaround, this is my final code, but I'd still love an answer why the original code wouldn't work. I've definitely used rows(1:1) on its own without specifically saying activesheet before.

Please Login or Register  to view this content.