I'm not sure, but if I'm the OP, I'd definitely appreciate/prefer to
receive
and try out any ideas/suggestions than not to receive any response to try.
Whether the suggestion(s) ultimately work or not when plugged into the
"real-world" application, of course, is another matter which could be
followed-up in further feedback within the thread or as a fresh post. Just
my views ..

I agree completely.

Thanks for the text string pointers. I'll definitely check those out!

Biff

"Max" wrote in message
...
Easy there, Max!
I'm not "knocking" anything.
It was just a question out of my own curiosity

No prob, guess sometimes it's good to discuss things
(and to clarify any possible "unwritten" underlyings)

Btw, do you do full testing on detailed posts
like this one before you respond ?
Yes, I do.

My sincere compliments, Biff !
I don't think I can/be able to measure up to this standard. g

.. That's one of the reasons I didn't want to "tackle" this one! ...

Ok, here's where my thoughts may differ slightly from yours. If imo,
there's a possible way (known to me) to suggest for the OP to try and get
it
done w/o too much trouble (read: a formula, or a couple of formulas easily
propagated across/down) which hasn't yet been posted in responses to the
OP
at that time, then I'll probably plunge right-in & suggest (after some
light
testing, of course).

I'm not sure, but if I'm the OP, I'd definitely appreciate/prefer to
receive
and try out any ideas/suggestions than not to receive any response to try.
Whether the suggestion(s) ultimately work or not when plugged into the
"real-world" application, of course, is another matter which could be
followed-up in further feedback within the thread or as a fresh post. Just
my views ..

.. I need to get something that does the same thing but
generates random text strings.

Probably known to you? since you were in this googled discussion
back in 2003 g: http://tinyurl.com/d82tf

Perhaps the Sub MakeRandPasswords() posted by Greg Wilson
therein seems quite a neat way (imo) to get it up ?

I tinkered around a little with Greg's code:

'Dim i As Integer, ii As Integer, PW As String change to Long
Dim i As Long, ii As Long, PW As String
...
For i = 1 To 65000 'Change to select number of passwords to generate

and ran the sub with say, B1 selected. Greg's sub generated the full 65K
random strings in col B within 15 sec. Cheers.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--