The attached file demonstrates that the CurrentArray (Range Property) is
not working in MS 2010 VBA Functions as described* (though it does run
correctly in macros). The following facts both describe how the file works
and also provide simple steps to recreate the file for yourselves if you
don
OK I modelled this to work with QX (see 'ForLouisZA.xls' in the files
section), however, can't you just take the total per time interval and
divide by the number of days in the total database? In the model, I've
shown both ways of doing it. The model has 30 min intervals from 6am
to 8pm, 16-20 Apri
gt; > you. I will incorporate into my actual data. Thank you very much for
> > taking the time
>
> > On Apr 13, 9:57 am, Dougie Excel
> > wrote:
>
> > > Sorry, I have now found the group file section and will use it myself.
>
> > > Stephen, your
e
the 'right thing to do' ;^)
On Apr 2, 5:15 pm, Dougie Excel wrote:
> http://www.douglaswilliamsmith.net/Excel_Functions/
>
> Frequent use of database functions in Excel over my career prompted me
> to start making an enhanced ‘user defined’ function in Excel for
> retrie
file section. Have attached it
> herewith.
>
> AJ
>
> On Tue, Apr 13, 2010 at 3:39 PM, Dougie Excel
>
>
> > wrote:
> > As Paul Willekens said, you've not uploaded anything.
>
> > The easiest solution to your task *sounds* like it would be a pivot
As Paul Willekens said, you've not uploaded anything.
The easiest solution to your task *sounds* like it would be a pivot
table (just google 'excel pivot tutorial' or something and you'll find
out all you need).
The QX Function* can summarize databases on unique criteria as well,
but being a VBA
http://www.douglaswilliamsmith.net/Excel_Functions/
Frequent use of database functions in Excel over my career prompted me
to start making an enhanced ‘user defined’ function in Excel for
retrieving data from Excel databases in the mid 90’s. In the meantime,
functionality has been continually adde
That was GOLD, Chris! Thanks! The scripting object evaluates user code
input and avoids BOTH problems:
1. The really weird problem (all other user functions outputting
#NAME? after any code-writing function is entered) is gone - users can
specify code in some cell that is in turn specified as the
For various reasons a user-defined function of mine needs to allow
user input that is interpreted as executable code (in this case any
excel expression).
The most straight forward approach would be for the function procedure
to input code into a module active in the same excel session and
subseque
