Copy range from sheet to word

jjsanders

New Member
Joined
Oct 16, 2006
Messages
36
Hello all,

How can I copy a range of col's from the current sheet to an word document using vba?

What I want is:

1. when i press the Button
2. Drop a word file in a certain directory
3. And the current sheet should be copied in that document.

How do i do this?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,657
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top