Color Palette in Excel VBA

Many a times you will need to show colors at run time for your cool Excel application. A good mix of Colors can make a application more att...

Using 'COUNTIF' function in Excel

The COUNTIF function counts the number of cells within a range meeting the specified criteria. For example, you can count the number of ti...

Get List of Files and Sub-Folders in a Folder

While working with VBA, one of the many common things to do will be, getting a list of files and sub-folder in a folder . The following cod...

Cricket Score Sheet - 50 Overs

If you play professional cricket every now and then, you will also love to maintain the scorecards in an organized manner. The below score...

Currency Exchange Rate Reporter

Do you regularly keep check on the currency rates? If the answer is yes, the below will prove more than useful to you. The below is a smal...

Using 'COUNT' function in Excel

This tutorial will cover the COUNT function of Excel. This function can be used to count the number of cells, within the specified range, ...

Implementing IF-ELSE logic in Excel

Like any programming language, you can implement IF-ELSE logic in Excel. The only difference if the way it is implemented. Lets consider t...

Using Nested 'IF' function in Excel

If you understand the IF function in Excel then please continue to understand how to use nested IFs. Otherwise please go through the below...

Using 'IF' function in Excel

In Excel you can make use of IF function to test a condition and return the value based on whether the condition was met. The syntax if IF...