This is the macro I use. It works for me for large chunks of Excel. But it
may not come out the way you like it. Fell free to use and tweak as
required.

Sub PasteTable()
'
' PasteTable Macro
' Macro recorded 6/20/2003 by Authorized User
'
Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF, Placement:= _
wdInLine, DisplayAsIcon:=False

Selection.Tables(1).Select
Selection.Shading.Texture = wdTextureNone
Selection.Shading.ForegroundPatternColor = wdColorAutomatic
Selection.Shading.BackgroundPatternColor = wdColorAutomatic
Selection.Font.Color = wdColorBlack
Selection.Font.Name = "Times New Roman"
Selection.Font.Name = "Times New Roman"
Selection.Font.Size = 10
WordBasic.TableRowHeight RulerStyle:=0, LeftIndent:="0", Alignment:=0, _
AllowRowSplit:=1, TableDir:=0
Selection.Cells.AutoFit
WordBasic.TableRowHeight RulerStyle:=0, LeftIndent:="0", Alignment:=1, _
AllowRowSplit:=1, TableDir:=0
WordBasic.TableRowHeight RulerStyle:=0, LineSpacingRule:=0, LeftIndent:=
_
"0", Alignment:=1, AllowRowSplit:=1, TableDir:=0

End Sub

Ed

"Robin Clay" wrote in message
...
Ed responded to my cry, 2003-10-15 14:13:43 PST

for which, many thanks.

I do a lot of the cut-and-paste you're talking about,

....erm... so do YOU have a Macro for it ? <grin

though not on that big of a scale.

45 pages. Yes, that, I fear may be the big challenge....

You don't need to write the macro in Excel, but in Word

Well. I had thought that, by using both, I could break
the operation into small bits, that would not crash WORD -
for I wrote in here, 10/15/2003 5:54:10 AM:

When I tried an ordinary cut 'n' paste, WORD crashed....
I guess I was trying to paste too much data.

- so you may want to take this over to
a Word newsgroup

Thanks, maybe I go there later.

walk through it in Word with the macro recorder on.

I'll try that.

Here's what I did for my stuff:

Thank you for your suggestions - I'll give it a whirl.

Good luck.

Thanks ! I guess I may need it... :(