It wasn't that it was obfuscated, but you want to the trouble to compute it
and then never used it - so I think you left some of the logic of your code
out. As written, you code offers no protection for not finding a match.
But it is a moot point anyway as the OP doesn't seem to know how to use
code.

--
Regards,
Tom Ogilvy

"pikus " wrote in message
...
That was pretty obfuscated huh? It stood for Sheet2Length. It made
sense while I was writing it. - Pikus


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