- 1). Add the "Developer" tab to the menu ribbon if you haven't already done so. Do this by clicking on the "File" tab on the left end of the menu ribbon. Click on "Options" and then on "Customize Ribbon" in the categories pane. Select "Developer" from the list of main tabs and then click "OK." The "Developer" tab should now appear in the ribbon.
- 2). Click on the Developer tab and then on "Visual Basic" to open the Visual Basic Editor window.
- 3). Insert the following line into your macro's code to use VB script to autofit cells in Excel:
Worksheets("Sheet1").Range("A1:E1").Columns.AutoFit
The information in parentheses after "Worksheets" is the name of your worksheet (usually "Sheet1"). The information in the parentheses after "Range" is the range of columns or rows or the single cell you want to autofit. You can change "Columns" to "Rows" if you want to autofit the height of the cell(s) rather than the width.
- Advertisement -
"Technology" MOST POPULAR
- Advertisement -
EDITOR PICKS & Articles
- Daswell Mobile Concrete Mixer With High Efficiency On Sale
- SEO Tools Reviewed - The Basics That You Should Invest In
- Do You Make These Common SEO Mistakes?
- Explaining Straightforward Plans For Chiropractic Care
- Know More Information About Airplane Ads
- imperative that you keep your eye on the important
- Most Excellent Ways to Advertise
- Make Money Online From Your Home
- Easy Email Marketing Techniques To Increase Your Traffic
- Advertising scenarios in different Indian cities
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
"Technology" Categories
Stay With Us
"Technology" MOST POPULAR
"Technology" Lastest Articles