Auto adjust for cells according to value using VBA

[LalitPandey87]

Hi,

Is it possoble through VBA to auto size the cell width according to the value in it.

Thanx in Advance.:cool:

[Excel Fox]

Are you looking for
Activecell.EntireColumn.Autofit? This will adjust the width of the column. If this is not what you are looking for, can you clarify with an example?

[Mahesh]

Perhaps ! u can use this also


Sub test()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
On Error Resume Next
sht.Activate
Cells.EntireColumn.AutoFit
Next sht
End Sub

[LalitPandey87]

Thanx for this useful function.
Working!
:cool: