In VB\Excel resize cells

[q4s72534]

ex:


|this is my exa| |Ye| |1|

It should say:

|this is my example| |Yes| |10|

In vb i want to record a macro in excel, higlight everything and clik something that will resize the cells according to the data in them. Is there a way to do this all at once?

Thanks.

 

[Zathras]

Just do it!

You should see something like this in your recorded macro:
[blue]

    Columns("A:C").EntireColumn.AutoFit

[/color]