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 ...
How-To Geek on MSN
How to use R1C1 referencing style in Microsoft Excel
R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.
How-To Geek on MSN
How to use the REDUCE function in Microsoft Excel
Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex ...
Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...
Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results