Excel Functions

This category holds all the posts which are related to Functions which are very useful while writing Macros.

Filter by Cell Color in Excel

In Excel 2007/2010, it is very easy to filter rows by Cell Color. In Excel 2007/2010 we have inbuilt functionality to do so. There can be two way to do this Filter by Color. Follow the below Steps to Filter by Cell Color in Excel 2007/2010: 1. Select the Range where you want to apply the Filter. […]

DateAdd() Function

DateAdd() Function This function returns a date value based on adding an interval of time. It will be more clear by going through the following […]

Wait Function

Even more wait for Gane of thrones New Season??? Noooo !!! Who in real life would like to wait… especially for Game Of Thrones 😀 No one would like to wait for any thing in real life 🙂 Waiting For Game Of Thrones Season – 7 Sometimes, while doing Automation in Excel Macro we require a “Wait” or “Sleep” function, which will hold the execution of the next statements until the specified time. Following is the Syntax, of Wait […]