I am trying to replicate the array formul
{=((SUMIF(N4:N23,"<0"))/(N36*COUNT(N4:N23)))} in VBA but the range wil
change each time the program is run, so I cannot hardcode that part. I
there a way to write this to allow for range flexibility or just t
solve the formula in the code and return the value straight to th
worksheet? Thanks

--
akondr
-----------------------------------------------------------------------
akondra's Profile: http://www.excelforum.com/member.php...fo&userid=1514
View this thread: http://www.excelforum.com/showthread.php?threadid=26781