Microsoft Excel allows us to create Custom Excel Functions or User Defined Functions using VBA. We can create Custom Excel Functions with the functionality we want and they can be accessed in the ...

An argument represents the value that you pass to a procedure parameter when you call the procedure. The calling code supplies the arguments when it calls the procedure. When you call a Function or ...

Sometimes at work we need to calculate specific metrics, KPIs or just simple percentages, with this principles you can create virtually any calculation you need for work. Having these calculations as ...

Greg Galloway has done some really cool things on the Analysis Services Stored Procedure Project which I’ll be blogging about soon, but in the meantime as part of his research he’s found an ...

As an Excel user, you may be familiar with the basic concepts of cells and ranges. But when it comes to using Visual Basic for Applications (VBA) to work with Excel, it’s important to have a deeper ...

This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. <BR><BR>Now I want to convert ...