Related:
- Excel fill cell with dots
- Excel dots in cells - Best answers
- Excel if cell contains text then copy to another sheet ✓ - Forum - Excel
- Excel if cell contains date then return value ✓ - Forum - Office Software
- Excel blinking cell without vba ✓ - Forum - Excel
- Excel blinking cell code - How-To - Excel
- Excel if cell contains date ✓ - Forum - Excel
3 replies
TrowaD
- Posts
- 2675
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 5, 2020
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.
Subscribe To Our Newsletter!
