The "wrong" way: Sub FindTotals()
Dim rCell As Range
For Each rCell In Sheet1.Columns(1).Cells
If Left$(rCell, 5) = "Total" Then
'Do something
End If
Next rCell
End Sub The "right" way: Sub FindTotals2()
Dim rCell As [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/04/28/testing-strings-using-left/
Posted
Apr 28 2008, 12:44 PM
by
Daily Dose of Excel