> ... I also had a d'oh moment when [snip]
Sometimes the best moments. I have a somewhat related saying:
"They say we learn by our mistakes. BOY! am I learning now!"
> As to only grabbing...unanswered questions in the first place:
> this was perhaps a bit of 'do now, think later' on my part. ...
> it's become a habit of mine to...
No prob. as they say. If it's comfortable (and works), do it.
Software is like that.
> ...one has to check ... either before ... or after.
> If before,...This...is slow, compared to ...data...
> in[to] an array (hence, 'stick it into an array').
I was thinking it would take less time to only load the
unanswered, a subset... Cuz...I assumed you *were* doing a
cell-by-cell loop... (:-(
I gather that there is an "official" VBA *Method* which loads an
array from, I can guess, a range of cells. BAM! I may have seen this
in my prowlings for VBA knowledge, but skipping it.
> I certainly have very limited experience in VBA programming,
No shame in that. Same here. I'm an RF Engineer turned, well,
lots of things. Manager, Programmer, laser show designer, home
builder, Self educated as well on VBA... I've been at VBA only abt 4
years, but Excel macros for a while. I did quite a bit at work, but
now control my Ham radios via serial port using Excel macros. Pretty
neat. Click and the radio tunes to a frequency, or uploads /
downloads several hundred memories. I may, some day, do Doppler
correction for talking through an Amateur Radio Satellite - we have a
couple dozen up there.
Lots of "Google-Time", lots of confusion trying to decode the
software-eese explanations.
Whatever works for you is just fine, I was only suggesting
alternatives, but you're ahead of me on this one.
> ...loading an array with only data meeting particular criteria...
Not'a clue..