Related:
- Excel dots in cells
- Excel fill cell with dots - Best answers
- How to fill cell with dots in excel - Best answers
- Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
- Excel vba change cell color - How-To - Excel
- Duplicate rows in excel based on cell value ✓ - Forum - Excel
- Excel formula if cell contains date ✓ - Forum - Office Software
- Excel vba - change cell color based on value ✓ - Forum - Programming
3 replies
TrowaD
- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
Hi Jutulu,
You mean something like this?:
Best regards,
Trowa
You mean something like this?:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MyWidth As Currency
MyWidth = Target.ColumnWidth
Target.EntireColumn.AutoFit
If Target.ColumnWidth >= MyWidth Then
Target.ColumnWidth = MyWidth
Exit Sub
End If
Do
Target = Target & "."
Target.EntireColumn.AutoFit
Loop Until Target.ColumnWidth = MyWidth
End Sub
Best regards,
Trowa
jutulu
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
Hi Trowa,
I didn't want to use macros. However, there is a much easier way to do it. I sow it once and thought it was very cool, but never wrote it down and can't remember it. Thanks anyway. Hope can find the answer to it.
I didn't want to use macros. However, there is a much easier way to do it. I sow it once and thought it was very cool, but never wrote it down and can't remember it. Thanks anyway. Hope can find the answer to it.
jutulu
- Posts
- 34
- Registration date
- Monday March 10, 2014
- Status
- Member
- Last seen
- September 21, 2015
Great! It was just that. Thank a lot. Only, you mean to go to custom option at the bottom, not number
