Hello. I have a loop checking to see if a given cell in a specified column begins with a semicolon or a blank space. Some of the cells begin with 0 or 1 semicolons or spaces and some of them begin with multiple. It works and does exactly what I need it to. It is just too slow because I am dealing with good sized files. Is there a faster way to do this? Code is below. Thank you.
/begin code
Range("R2").Select
Dim myString As String
myString = Selection.Cells.Value
Do While IsEmpty(Selection.Cells.Value) = False
Do While Left(myString, 1) = ";" Or Left(myString, 1) = " "
Selection.Cells.Value = Right(myString, Len(myString) - 1)
myString = Selection.Cells.Value
Loop
ActiveCell.Offset(1).Select
myString = Selection.Cells.Value
Loop
/ end code
Bookmarks