Yes. Couple of tips: use datatypes on your parameter declarations and your Function declaration, and "Range" is a (very commonly used) object in Excel so picking a different name for your function ...

While Excel boasts over 450+ functions, sometimes they just donâ t cut it. These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your ...

To create a custom function in Excel VBA, you need to enable the Developer tab and go to the Visual Basic panel. Next, right-click on Microsoft Excel Objects > Insert > Module and enter the code.

VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.