tonyrosen
12-19-2005, 02:37 PM
Here's what I'm TRYING to figure out.
Let's assume that you "Select" column B ...
How would I go about checking each cell in Column B?
For Each Cell in Range("B:B")
iData = Value.Cell
If Len(iData) < 4 Then
'Do this
End If
Next
Obviously, this gives me EVERY cell, but I only need to check the ones with data in them.
Let's assume that you "Select" column B ...
How would I go about checking each cell in Column B?
For Each Cell in Range("B:B")
iData = Value.Cell
If Len(iData) < 4 Then
'Do this
End If
Next
Obviously, this gives me EVERY cell, but I only need to check the ones with data in them.