Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Paste from Excel
Hi All
Using a table in Word set up to same size as an Excel sheet covering cells A1 : I20 on copying Excel then Inserting in to Word on first effort Word does not show Paste Cells just Paste if I paste and then undo -- Paste Cells then becomes available and inserts ok in Word Table. Have tried to do a little macro to do the job for me however cannot find Paste Cells available when doing so. Macro reads as follows; Sub Macro1() Selection.MoveRight Unit:=wdCell, Count:=10 What code would I need to insert to Paste Cells from the Excel sheet End Sub Any help much appreciated Cheers Mully |
#2
|
|||
|
|||
Paste from Excel
Hi mully-
Unless you intend to work this into a much more extensive procedure, why not just use EditPaste Special and choose either Formatted Text (to get a Word table) or MS Excel Worksheet Object (which can be revised using Excel)? Regards |:) "mully" wrote: Hi All Using a table in Word set up to same size as an Excel sheet covering cells A1 : I20 on copying Excel then Inserting in to Word on first effort Word does not show Paste Cells just Paste if I paste and then undo -- Paste Cells then becomes available and inserts ok in Word Table. Have tried to do a little macro to do the job for me however cannot find Paste Cells available when doing so. Macro reads as follows; Sub Macro1() Selection.MoveRight Unit:=wdCell, Count:=10 What code would I need to insert to Paste Cells from the Excel sheet End Sub Any help much appreciated Cheers Mully |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste excel data to word problem | Microsoft Word Help | |||
Paste formatted text from Word into Excel. | Microsoft Word Help | |||
Paste a range of Excel cells into Word as a link, cell outlines vi | Page Layout | |||
How do I paste linked Excel Worksheets into Word without gridlines | Microsoft Word Help | |||
Paste special from Excel | Page Layout |