EXCEL MACRO

I have a excel spreadsheet that is published to HTML as a report every day. When published, it publishes the full worksheet. I only need to print out a specific area on this worksheet. Can anyone provide an excel macro or script to print out a specific area of a worksheet when published to HTML.