vba code for autofit columns in a worksheet

**JEAN1972** · 08-01-2016, 10:29 AM

Hi

Looking for a vba code to autofit columns in a worksheet

Thanks

**AB33** · 08-01-2016, 10:40 AM

**Winon** · 08-01-2016, 10:44 AM

Hello JEAN1972,

If you are running it from a Module then the below could work for you;

Please Login or Register  to view this content.

Regards.

**AB33** · 08-01-2016, 10:46 AM

Hi Winon.
columns.autofit
will do as well

**YasserKhalil** · 08-01-2016, 10:57 AM

Try this

Please Login or Register  to view this content.

I apologized for not seeing other posts .. Poor internet connection

**AB33** · 08-01-2016, 11:02 AM

Winon could sympathise with you on the black out.

**Winon** · 08-01-2016, 11:08 AM

Agreed AB33, Columns.Autofit will suffice.

How do you know about our blackouts

Kind Regards.

**AB33** · 08-01-2016, 11:11 AM

Well, you mentioned in one of your threads- there is constant black out in some part of SA. It might be the same in Egypt.

Re: vba code for autofit columns in a worksheet