Give the table a name under InsertNameDefine

Then select a cell and run this macro.

Sub copytable()
Range("mytable").Copy
ActiveCell.PasteSpecial
Application.CutCopyMode = False
End Sub


Gord Dibben MS Excel MVP

On Fri, 17 Oct 2008 14:55:53 -0700 (PDT), RobcPettit
wrote:

Hi, I was wondering if there was something simular to autotext in
excel. In word Ive saved a table layout and inser when needed. In
excel I have the same table layout which I copy and paste when I need
another table. What Im doing is on sheet1 I have my table 20col by 40
rows. I like to repeat the table underneath eah table on the sheet. I
dont want to use a new sheet. I have a macro that copys and pastes
these for me. I have to keep the original on a sepperate sheet to copy
from so theres no data. Hope this is clear
Regards Robert