Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have been trying to create my own function whilst including othe functions. Please see below example Function ShiftHours(a, b, c, d, e) ShiftHours = SumProduct(--(a = b), --(c = d), e) End Function This however doesnt work. Can i use functions within functions? If so how would i use an aray function that would normaly require me t use shift&Control&Enter at the same tim -- ceem ----------------------------------------------------------------------- ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065 View this thread: http://www.excelforum.com/showthread.php?threadid=55884 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Function ShiftHours(a, b, c, d, e)
ShiftHours = Evaluate("SumProduct(--(" & a & "=" & _ b & "), --(" & c & "=" & d & "), " & e & ")") End Function Would be the basic approach. the contents of the variables would have to be consistent with that approach to foster success. -- Regards, Tom Ogilvy "ceemo" wrote: I have been trying to create my own function whilst including other functions. Please see below example Function ShiftHours(a, b, c, d, e) ShiftHours = SumProduct(--(a = b), --(c = d), e) End Function This however doesnt work. Can i use functions within functions? If so how would i use an aray function that would normaly require me to use shift&Control&Enter at the same time -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=558846 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not like that
Function ShiftHours(a As Range, b, c As Range, d, e As Range) Dim sFormula As String sFormula = "SumProduct(--(" & a.Address & "=""" & b & """)," & _ "--(" & c.Address & "=""" & d & """)," & _ e.Address & ")" ShiftHours = Application.Caller.Parent.Evaluate(sFormula) End Function -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ceemo" wrote in message ... I have been trying to create my own function whilst including other functions. Please see below example Function ShiftHours(a, b, c, d, e) ShiftHours = SumProduct(--(a = b), --(c = d), e) End Function This however doesnt work. Can i use functions within functions? If so how would i use an aray function that would normaly require me to use shift&Control&Enter at the same time -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=558846 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Im thinkiing that as long formulas accross many cells can slow an excel workbook down so its takes a few seconds to calculate using functions could speed up the process ? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=558846 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Putting the same formulas in functions would only make it slower.
-- Regards, Tom Ogilvy "ceemo" wrote: Im thinkiing that as long formulas accross many cells can slow an excel workbook down so its takes a few seconds to calculate using functions could speed up the process ? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=558846 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |