I have a VBA code to calculate a "conditional average" of the days used
to issued official documents, given a range, and ID of the entity and
the column I want to calculate.
When I use the function in the same sheet I have the information to be
calculated, it works well. However, when using it in a different sheet
(of the same workbook), an error message is displayed.
It seems there's a reference problem when working with ranges, but I
have not found how to solve it.
Does anybody know what should I change for this function to work
properly?
Thank you very much in advance!


--
Andres
------------------------------------------------------------------------
Andres's Profile: http://www.excelforum.com/member.php...o&userid=26096
View this thread: http://www.excelforum.com/showthread...hreadid=394273