VBA function - Find max value of a range

[rgimblett]

Hi,

I''ve been teaching myself VBA as a first step into programming with Office. A little over a year ago I got some help to solve an array formula topic as below
http://www.excelforum.com/excel-form...ric-value.html

As a first trial i've tried to achieve the same result using VBA. I've tested the VBA as a sub routine and it returns the largest value in an active selection range which was perfect. But when I change it to a function it throws a an invalid name error. So my question is any pointers on why this works as a subroutine but not a function? Secondly if you're able to suggest better VBA to achieve the same ends please do.

Please Login or Register  to view this content.

[mrice]

Where is the code sitting - it needs to be in a module and not the ThisWorkbook tab.

[rgimblett]

The code is in a module of the workbook I want to use it on.
I should say I'm using Excel 2010. I intend for this to work on Excel 2003 as well.