store it into your personal.xls
then assign a shortcut to it via macro's options.

if you dont have a personal.xls
start macro recorder ,select personal macro workbook .
record something and it will be created for you.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


tom wrote :

It works !

It is a database that generates the xls file, so I have
te make the macro again and again and again ...
Is it possible to integrate the marco into the basis
marco's of excel ?

thx
Tom

-----Original Message-----
Tom,

try
activesheet.columns.autofit
activesheet.rows.autofit




--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Tom wrote :

Hallo,

I dubble clic on the dividing lines to make
automatically
the row or colulmn as big as the biggest cell.

I have a lot of cells that have to be resized.
Is it possible to resize all the row and
columns with a macro ?

Thx in advance
Tom
.