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