I see. I assumed that it would compute as a range similar to using the max function in the application. I see now even when using application functions in vba, I need to explicitly state a range.

Thank you for the help!