Excel VBA - StandardWidth property

Sign-in

Sign-out

Last

A.I.

WebHosting

ASK

RECENT

JOb

Forum Policy

Read:

Hide:

Show

Please input correctly

You are logined,Please click reply OR ask tag,USER_ID:

Server is busy or in error, if still in problem, please send us email at support@

STOCK

Below area will not be traslated by Google,you can input code or other languages
paste code or other language below=>click Code(Run code, select all=>click STEP icon=>click Code)

Current Browser:

Update your Chrome/Edge to >=130.0.0.0 version
to get faster future/News data: Install/Update Chrome

This area is developing message box

https://wetalk28.us

News即時新聞:↓

更新

News即時新聞:↑

更新

On Balance Volume (OBV):

Option:

Youtube Video♬ Sharing by members:↓

Youtube Video♬ Sharing by members:↑

Ask Question Forum:

Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page

Show

ASK RECENT

Excel VBA - StandardWidth property

Asked by brothertruffle880

at 2024-07-21 02:39:13

Point:500 Replies:3 POST_ID:829053USER_ID:11832

Topic:

Microsoft Excel Spreadsheet Software;;

I have about 14 columns which have been modified to different sizes. I would like to bring them all back to the standard width as defined in the properties window. What is the VBA code to do this?

Expert: test test replied at 2026-04-13 23:18:58

Range("A:N").UseStandardWidth = True

Accepted Solution

Expert: Rory Archibald replied at 2024-07-21 03:01:36

250 points EXCELLENT

You can also use:

Range("A:N").UseStandardWidth = True

1:

Select All Code

for specific columns for example.

Assisted Solution

Expert: duncanb7 replied at 2024-07-21 02:44:11

250 points EXCELLENT

Try this as follow

Duncan

Sub test()ActiveSheet.Columns.EntireColumn.ColumnWidth = ActiveSheet.StandardWidthEnd Sub

1:2:3:

Select All Code

Privacy Policy私隱政策

免責聲明：以上資料僅作參考之用
computer28.com對以上資訊的準性和可靠性不能亦不會作
任何保證或承擔，並對資料或有關的錯漏或延誤而作出的任何
決定或導致的損失概不負責.
Disclaimer: The above information is for reference only,
computer28.com cannot and will not provide any guarantee or
commitment for, and not responsible for any decision or loss
caused by the information or related errors,omissions or delays.

Our All Domain Name: Public Main Server:computer28.com Public Video Server:computer28.online Public WebHosting Server:computer28.cloud Public Mail Server:smtp.computer28.com Public Main Server at USA:computer28.us Private Video Server at USA:wetalk28.us Public BackUp server:computer28.us

Internet Security: CloudFlare A.I. Bot & CDN Security Protection:Enabled Google Sign SSL Trust Certificate:Enabled Google-sign-in:Enabled Note:Google-Sign-in,Google just let us know your gmail.com account is yours & Google will NOT expose your password to us opendkim Mail Security Test:computer28.com DKIM is passed DKIM You can check your every gmail.com email is secure or not, just click any email then click 3-dot ,then click "Show Original"

Our All Data Center Location: Online:Singapore,USA Pending:France,German,ShenZhen,Beijing(after 2 or 3 months)

Please support computer28.com for continuous website design, A.I.,Free Video Conference,Free WebHosting,Free YourDomain.com Mail Server, I.T. devlepment. Your Donation Support is tremendous encouragement(極大的鼓勵) to our team. Thanks

新聞財經娛樂♬資訊 News Economy

About Us|Service|Pricing

&nbps;

News即時新聞:↓

News即時新聞:↑

On Balance Volume (OBV):

Youtube Video♬ Sharing by members:↓

Youtube Video♬ Sharing by members:↑

Ask Question Forum:

Excel VBA - StandardWidth property

Your Information

Members/Profolio