I have allready had the answer

with a macro :
activesheet.columns.autofit
activesheet.rows.autofit

Tom

-----Original Message-----
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 with one clic to resize all the row and
columns ?

Thx in advance
Tom
.