Monthly Archives: June 2009

Excel Extract Cell Comments

Posted on June 19, 2009 by Admin

Excel VBA/Macro example below will extract comment from every cells with comment, and put the summary in the cell selected by user using Excel input box (read more about how to get cell reference using input box here). Sub CreateCommentsSummary() … Continue reading →

Posted in Cells and Range | Tagged , , , , , | 7 Comments

How to get an Acronym using Excel VBA?

Posted on June 17, 2009 by Admin

The purpose of the following example of Excel VBA macro is to get the acronym or an abbreviation of each of the first letter of any given words. Function Acronym(Words As Variant) As String Dim aWord() As String, ix As … Continue reading →

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

Get Position of Last Column Containing Data with Excel VBA

Posted on June 13, 2009 by Admin

If you read my latest update on how we can get position of last row containing data, then most probably you already have a glimpse on how we perform the same task with last column containing data in Excel. The … Continue reading →

Posted in Cells and Range | Tagged , , , , , , , , | 56 Comments

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 , , | 7 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 , , , , , , | 9 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 , , | 13 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 , , , , , | 4 Comments