Columns resize event

mihaij · October 18th, 2005, 12:51 PM

Hello there,

I need to handle the columns resize operation in an Excel Worksheet but I don't know what event is generated when the column is resized (using mouse drag) and how to capture this event in the VBA code of the Excel document.
Any help is apreciated.

mihai

ix_ly · October 23rd, 2005, 07:44 PM

Hi mihai,

maybe you could try to record the macro and discover the code involved.

However, i think the following code might help you.
Columns("A:A").EntireColumn.AutoFit
Rows("10:11").EntireRow.AutoFit

nick

ix

vemaju · October 27th, 2005, 12:11 PM

Hi,

There's no such an event as Column_Resize.

-vemaju

ix_ly · November 9th, 2005, 09:05 PM

Hi,

For AUTOFIT the column width, you can use this event
Range("A1").EntireColumn.AutoFit

For MANUALLY set the column width, you can use this event
Range("A1").EntireColumn.ColumnWidth = 20

:D

ix