You can create custom Excel functions using VBA matching using your criteria. Create custom Excel functions using Macros in Excel & use user-defined functions in Excel.

Excel-VBA-Projects Excel games, procedure, user define function, and other interesting stuff built on excel file with VBA ...

If you are writing a VBA script, do you have access to the excel functions? I tried to do a simple function for finding the range of a group of numbers and thought this would do it:Function Range ...

Visual Basic for Applications (VBA) is a programming language embedded in Microsoft Office that can be used to automate processes and build functions.