-----Original Message-----
1. I am surprised it works at all because you have, in
effect, an
endless loop - no method of exit from
'-------------------------------
Do

Loop
'-------------------------------

You probably get an Overflow error when Excel runs out of
memory (if
you are lucky).

2. The use of Empty is not really correct because it
usually refers to
a defined object variable. I don't know if this makes any
difference
though. More usually we use "" or 0. eg.
If Range("CA" & liRow).Value < "" Then ..............


---
Message posted from http://www.ExcelForum.com/

.
If you would have looked at the all the postings for this
question you would have found out that I took some code
out of there for security reasons. The loop had a break
point I just included the part of the code that wasn't
working. The "Like" test wasn't returning true when it
should have, that was the problem. I appologize for not
being specific enough.

As far as "Empty" goes, I got used to using it because I
have come across situations where < "" didn't work. I
can't remeber specific examples but generally it was
because of something the user did. As a result I found
that "Empty" was a good catch all.