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

Macros are powerful, but they don't work on the web or mobile. I’ve switched to the native REDUCE function for my complex data tasks.

Problem:<BR>Where a VBA procedure has been developed referencing specific cells, the user of the spreadsheet then decides to insert a new row or col, which has the affect of offsetting all of your ...