Hey, I need to export a certain cell range from an excel file into a word document or pdf file. The range can be exported as a picture or anything like that as long as size and format remain the same. Im pretty sure this needs to be done with VB, but i have no knowledge of VB at all. Please help!

I know that I can just copy/paste into word, but I would like to place a button or something of that nature on the spreadsheet that would export a specific range to a file when you click it. It would be great if this file would just be created on the desktop but I am open to all suggestions.

Thanks!

Let me know if further explanations are needed.