predisigned table

R

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top