Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Wayne Crawford   on Jan 01 In MS Office Category.

  
Question Answered By: Ned Storm   on Jan 01

> ... 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..

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on List in one sheet unanswered questions in checklist sheet Or get search suggestion and latest updates.


Tagged: