Selasa, 25 Oktober 2016

Re: [ExcelVBA] failing function


You're completely welcome.
From a personal standpoint, I always put forth a LOT of effort to find the problem before I resort to asking for help.
But at the same time, I tell people (and my co-workers) that they should ask early to AVOID the struggle.
Very much a case of "do as I say, not as I do".

Still, it's really embarrassing to them when they spend several hours trying to figure out the problem and I spot it in 3-5 minutes.

Do you use the VBEditor debugger much?
That is, setting a "breakpoint", then step through the code one line at a time while monitoring variables in a "watch" window?

In your case, you might have quickly been able to see when your code encountered a problem and exited prematurely.

"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley

On Tuesday, October 25, 2016 12:44 PM, " [ExcelVBA]" <> wrote:

    OK, I should have known this (easy enough to say after the fact), but I found the flaw in calculations not in my function call.   Needed to define the arrays correctly, and bingo there was the problem.  (Of course I had to spend the time putting the function together line group by line group, but it found the error!)

Thanks to all who answered!   And Paul for reminding me of the obvious to check my calculation before asking for help. 



Posted by: Paul Schreiner <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (12)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar