Auto Fit Columns

Sub AutoFitColumns() ‘ Smart code for Autofit all columns of Active Worksheet ‘ Smart Excel(anilnahar.com) Cells.Select Cells.EntireColumn.AutoFit End Sub
Alphabets Serial Capital And Small Letter

Sub Alphabets_capital() ‘ Smart code for Serial Alphabets in Capital Letters from select cell ‘ Smart Excel (www.anilnahar.com) Dim i As Integer For i = 65 To 90 ActiveCell.Value = Chr(i) ActiveCell.Offset(1, 0).Select Next i End Sub ————— Sub Alphabets_small()…