predisigned table

[RobcPettit]

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

 

[Gord Dibben]

Give the table a name under Insert>Name>Define

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