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.

R1C1 coordinates provide a predictable map for auditing formulas and writing universal VBA macros.

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