resize row and colomn height

[Tom]

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

 

[keepITcool]

Tom,

try
activesheet.columns.autofit
activesheet.rows.autofit




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


Tom wrote :

 

[tom]

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

 

[Tom Ogilvy]

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

 

[keepITcool]

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 :