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 ...
Kenji Explains on MSN
Split Excel data into multiple sheets automatically
In this video, learn how to split data into multiple worksheets in Excel, such as separating total sales into quarterly ...
How to use the FILTER() dynamic array function in Excel Your email has been sent Filtering is a huge part of many Microsoft Excel sheets, and fortunately, there are ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback