Question about Error Handling + multiple msg boxes

I have a simple function here that performs a calculation on a range of values. The range will always have 5 values. The range should also be one dimensional.
In an attempt to cover an out of range case, I have tried to add error handling that will prompt the user of the functions limitation.

When I test a range with an x value >1 from a subroutine, I only get the error msg once. However, when I attempt the same range of cells from a worksheet, I get the error msg many times.

I don't understand why I would get different results from a worksheet vs. a subroutine.

Any help is greatly appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.