Author Archives: Admin

Find the Last Day of any Month

Posted on June 9, 2009 by Admin

Simple Microsoft Excel formula to find the last day of any given month. ‘ =DATE(YEAR(A1),MONTH(A1)+1,0) ‘

Posted in Excel Formula | Tagged , , | 1,891 Comments

Schedules to Refresh Data Automatically using VBA Macro

Posted on June 9, 2009 by Admin

I once asked by Joshuacht about how to make a macro running every 15 minutes. Let say because every 15 minutes we have to refresh or reload the data in the Workbook. Below is a sample of how we can … Continue reading →

Posted in Workbook and Worksheet | Tagged , , , , , , | 598 Comments

Excel VBA Add Set of Worksheets Automatically

Posted on June 8, 2009 by Admin

There is a time when we must create a set of Excel Worksheets templates on a regular basis in our work. For example, a set of Excel Worksheet for each month of the year or may be based on the … Continue reading →

Posted in Workbook and Worksheet | Tagged , , | 1,206 Comments

Auto Format Excel Cells with Error Value

Posted on June 3, 2009 by Admin

With the simple Excel macro below, we can make all cells in active Worksheet that contains Error value in it, like #NULL, #Div/0!, #VALUE!, #Ref, #NAME?, #NUM!, And #N/A, will automatically having cell format that different/stand out among all other … Continue reading →

Posted in Cells and Range | Tagged , , , , , | 1,775 Comments

Auto Expanding VLOOKUP Table Array

Posted on April 2, 2009 by Admin

Ok, this time I want to talk about how to create a vlookup table array that automatically expanding in accordance with the numbers of available data. As we know, the basic form of Excel VLOOKUP to look for A1 value … Continue reading →

Posted in Excel Formula | Tagged , , , , , , , , , , | 649 Comments

VBA Delete Excel Rows Based on Certain Date

Posted on January 31, 2009 by Admin

Let say I have a bunch of formatted data in my Excel sheet, and in Column A I have a dates. Then I wanna filter all the data base on certain date, for example 1 Jan 2009, and delete all … Continue reading →

Posted in Cells and Range, Workbook and Worksheet | Tagged , , , , , , , | 1,066 Comments

Number of Cells/Rows/Columns With Formula

Posted on January 29, 2009 by Admin

A few weeks ago I received this question from someone called LS: Hi I want to write a macro that counts the following – Number of cells with formula – Number of Rows with formula – Number of Columns with … Continue reading →

Posted in Cells and Range, Workbook and Worksheet | Tagged , , , , , , , , , , | 1,640 Comments