Hello, the code below is an amalgamation of recorded macros. As I have only limited skills in VBA, can one of the gurus here help me optimize this for efficiency and speed?
Range("A2").Select
Range("A2", Selection.End(xlDown)).Select
With Selection
Selection.NumberFormat = "General"
.Value = .Value
End With
Range("G2").Select
Range("G2", Selection.End(xlDown)).Select
With Selection
Selection.NumberFormat = "General"
.Value = .Value
End With
Range("h2").Select
Range("h2", Selection.End(xlDown)).Select
With Selection
Selection.NumberFormat = "General"
.Value = .Value
End With
Range("l2", ActiveCell.SpecialCells(xlLastCell)).Select
Application.Run "PERSONAL.XLSB!converttexttonumbers"
Bookmarks