I need a macro that takes a highlighted group of cells in a MS word
table...copys their formating (ctrl+shift+C)...pastes inforamtion that
was already copied from excel (ctrl+V)...than pastes the formating
onto those sames cells (ctrl+shift+V)...the major problem that is
encountered, is that the highlighted area is deslected after
pasting...so you must rehighlight in order to paste the formating into
it...I am looking for a macro that does all three functions with one
button on highlighted cells of varying length (3 rows, 2 columns...4
rows, 1 column, etc.)...thanks.

---

Request for Question Clarification by endo-ga on 16 Jan 2006 13:34 PST

Please let me know if the comment below helped, if it didn't I'll have a go.
Thanks.
endo

---

Clarification of Question by google_maniac-ga on 23 Jan 2006 16:30 PST

actually I don't want the oringial formating (formating in the excel
sheet)...I want the formatings that have been stored in the tables in
word...thanks.

Have you tried the command "Paste Special"? This allows you to paste
as text only, which will paste in the results but keep the existing
formatting.

actually I don't want the oringial formating (formating in the excel
sheet)...I want the formatings that have been stored in the tables in
word...thanks.

If you can give an example.i will easily this issue.

If you can give an example.i will easily resolve this issue.