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
6 simple Excel automations you can do in under 5 minutes
Stop doing more than you have to in Excel—built-in tools can automate repetitive tasks instantly.
Not sure if I'm asking this right, but I have an excel form that a user is asking me to attach formulas with IF...THEN statements to.<BR><BR>The form looks like this ...
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 ...
Hosted on MSN
Level up your Excel game with real skills
Excel isn't just for formulas—it's a powerhouse when you combine smart habits, automation, and the right functions. From ditching the tutorial trap to mastering VBA and data integrity techniques, you ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results