Posting entire sheet as html

I made a macro to post my sheet "PRINT" as an html file which worked perfectly. Then, I updated all of my info in a new sheet called "OVERVIEW". I want to be able to post this sheet as an html file instead of "PRINT" which is outdated. I get error 1004 "Method 'Publish' of object 'PublishObject' failed" I clicked the "help" button but nothing came up. Does anyone know what this means or how to fix my problem?

Here is my code, any help is appreciated:

Please Login or Register  to view this content.

Yes, and I read online somewhere else that activating another range first (e.g. "A1") would solve the problem, but I had no luck. I actually just recorded a macro and republished the sheet manually, and for some reason, that now works. I don't know why it wasn't before, but I fixed the problem. Thank you anyways!