Easy there, Max!
I'm not "knocking" anything.
It was just a question out of my own curiosity.
Btw, do you do full testing on detailed posts
like this one before you respond ?
Yes, I do. That's one of the reasons I didn't want to "tackle" this one! I
didn't want to fill 6 sheets with data! I have a custom toolbar button with
macro that generates random numeric values that I use for testing in "huge"
blocks of cells. I need to get something that does the same thing but
generates random text strings.
Biff
"Max" wrote in message
...
"Biff" wrote:
Max, I'm wondering if you did a full application test on this ..
Obviously not <g .
Btw, do you do full testing on detailed posts
like this one before you respond ?
6 sheets with 65536 rows of data, 3000 rows of lookup values
and 6 columns of formulas.
What kind of calc time did that take?
Ok, I just did that, on my laptop (3 year old IBM T30) Excel 97:
Took about 3 mins to fill the formulas & complete calc.
Perhaps you would like to indicate what other pre-emptive caveats
should have been written in my suggestion ?
Like always, it was only a suggestion for the OP to try out.
And nothing is ever stated in my posts that precludes
any others from posting other, possibly better suggestions
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--