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