Hi,

Title more or less sums it up.

I need some Excel VBA code to copy all the data on a sheet, with all its formatting (font, borders etc.), open an instance of a new word document and paste in the copied data so that it looks exactly like the Excel sheet. The important thing is that the Excel grid lines should not appear in the WOrd document.

Choosing to not display the grid lines in Excel doesn't seem to have any effect when pasted to Word using the code examples I've come across.

Usual TIA.