resize row and colomn height
 

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

resize row and colomn height
 

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

resize row and colomn height
 

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
.

resize row and colomn height
 

You could put the code in an event that fires it automatically based on some
action. Without knowing your exact situation, it would be hard to tell
which event would be appropriate, without being wasteful. You can look at
Chip Pearson's page on events and make your own decision if one of these
would be appropriate:

http://www.cpearson.com/excel/events.htm

and if workbook and sheet level events don't fit, perhaps an application
level event:

http://www.cpearson.com/excel/appevent.htm

--
Regards,
Tom Ogilvy

"tom" wrote in message
...
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
.

resize row and colomn height
 

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
.