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.

Build a custom Excel function library in minutes! Learn how to use VBA, create a personal macro workbook, and design a custom ribbon tab.

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 ...

When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.

Method 3: Creating Custom VBA Functions For users comfortable with coding, creating custom VBA functions provides an automated and efficient way to sum or count cells by color.

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. Now I want to convert it ...