You Can Change The Column Selection By Modifying The Value İn The Macro ("c: C") Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sutun seçimini makrodaki ("C:C") değeriyle oynayarak değiştirebilirsiniz örnek:("E:E") veya ("A:A") Kod: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rng As Range Set rng = Columns("C:C") If Not (Intersect(Target, rng) Is Nothing) Then rng.ColumnWidth = 30 Else rng.ColumnWidth = 10.71 End If End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 you can change the column selection by modifying the value in the macro ("c: c") 2 excel operators hk 3 Clicking column c expands and narrows when you click another cell 4 Writes the number of the row you clicked in column B to column A 5 Highlight replicators from selection: This macro controls each cell of your selection and highlights duplicate values. You can also change the color of the code. 6 adding two lines and removing total 7 Track and Report User Changes in an Excel worksheet or workbook 8 Highlight Specific Text: Suppose you have a large data set and want to control a specific value. You can use this code for this. When you run, you receive an input box to enter the value to search for. 9 cell-related codes 10 time format in active sheet / page and target cells 11 date format in active sheet / page and target cells 12 Automatic expansion and contraction of column c 13 Select and delete columns for a1b1c1d1 (delete with hold) 14 select cell values with auto-color in specific table 15 change other column depending on value. 16 row and column width 17 Capital letter in column c 18 automatically opening the column to the desired width when you click on the cell 2 19 automatically opening the column at the desired width when you click on the cell 20 Run macro codes when you enter values to a1