Column width auto as per data in cell

[needhelp2]

Hi All,


I need to know how i can set Column width auto as per data in cell?
Mean if enter data in cell its width will auto max as per need of data.



Thanks

 

[Nalani]

Try this in the Worksheet Code Module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Columns("D:D").AutoFit
End Sub

Works on column D. if you want it to work on all columns, get rid of the ("D:D") part.

 

[needhelp2]

Thanks dear Nalani.

Can you help me regarding data association?

 

[Nalani]

Glad it worked and thanks for the feedback.

Don't know if I can or not. But since Data Association is not related to this thread, I'd suggest starting a new one and be as explict as you can on your question.

What you have
What your required results should be
Version of Excel
etc, etc

 

[needhelp2]

Ok! Done thanks for your much cooperation.