How about 0.08 sec.
Sub TabLow()
'
' TabLow Macro
'
''PURPOSE: Determine how many seconds it took for code to completely run
Dim StartTime As Double, SecondsElapsed As Double
Dim lRow As Long, cel As Range
'Remember time when macro starts
StartTime = Timer
'*****************************
With Sheets("Test File")
lRow = .Cells(.Rows.Count, 3).End(xlUp).Row
.Range("C1:C" & lRow).Copy
.Range("A1:A" & lRow).Insert Shift:=xlToRight
.Columns(1).EntireColumn.AutoFit
Application.CutCopyMode = False
With .Range("A1:C" & lRow)
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
For Each cel In .Cells
If Len(cel.Text) = 1 Then
cel.Value = Val(cel.Value)
cel.NumberFormat = "00"
End If
Next
End With
End With
'*****************************
'Determine how many seconds code took to run and notify user in seconds
MsgBox "This code ran successfully in " & Round(Timer - StartTime, 2) & " seconds", vbInformation
'*****************************
End Sub
Bookmarks