Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by brothertruffle880
at 2024-07-21 02:39:13
ModifyPoint: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:
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
Duncan
Sub test()ActiveSheet.Columns.EntireColumn.ColumnWidth = ActiveSheet.StandardWidthEnd Sub 1:2:3:
