01-22-2026, 12:23 AM
(This post was last modified: 01-22-2026, 12:27 AM by ahenry3068.)
(01-22-2026, 12:09 AM)Pete Wrote: Probably stuff I don't need... unless you want to throw in 40 virgins, then I'd be happy to convert to IsNum. If this offended anybody, IsTooBad.
Pete![]()
@ahenry3068
I do like the IsNum one. Val by itself is insufficient, so the function must check each character of the string. It is cool that val() can detect some, like &H75, which returns 117 if I remember correctly.
Pete
The IsNum one is well optimized and one I use quite a bit, It's handy ! The other one's I just threw together on the Spot to show Phil how it could be done.
I knew right away they aren't well optimized. ! I typically don't care much about Is Upper or Is Lower. If I'm doing a comparison that needs to account for case
I usually force the case with UCASE before doing a comparison !
I could optimize it a little by using _orelse instead of or in few of those functions.

