For loop works for >1 but not for one or blank.
Posted on 2014-04-24
I am having issues with the following statement:
For Each cel In Range(Range("B1"), Range("B1").End(xlToRight))
There are times that there is one, and it must be going way right, because it keeps going and going. Other times is blank. How do I rewrite this so it works when it is one or greater, but if B1 is blank to allows for a msgbox?