View Single Post
 
Old 02-20-2020, 10:51 PM
Jennifer Murphy's Avatar
Jennifer Murphy Jennifer Murphy is offline Windows XP Office 2007
Competent Performer
 
Join Date: Aug 2011
Location: Silicon Valley
Posts: 234
Jennifer Murphy is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I can't see the point of that
The point is, as I said, initializing it to something that cannot be in the table. That way, the compare in the first pass through the loop will always fail, which is what I need.

But even if you cannot see a point, do you know if there is a Variant value that will fail a compare with any possible text value?

Quote:
- one could just as easily initialise it as:
StrTitle = ""
That fails if the data in the first row of the table is "". I admit that that is highly unlikely, but as Murphy (or someone) said, anything that can go wrong will go wrong.
Reply With Quote