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
- 2647
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 3, 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.
