well, i've figured out how to eliminate the extra pages, BUT, when I post a document onto my web page, if I created multiple worksheets within the document, none of them will show up on the web. So that is why i need to copy and paste each worksheet into a new workbook, and find a way to keep all of the formatting in the columns and rows.