Excelvbamacro - excelvbamacro.com
General Information:
Latest News:
Excel VBA: Empty Clipboard Excel 28 Feb 2011 | 02:55 pm
Do you ever think or need to clear/empty Clipboard Excel? I have a big Excel file which abusing the power of copy and paste to format the data and formula. I prefer to update the formula once, then sa...
How to Get a Full File Path in Excel? 20 May 2010 | 01:24 am
Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the active file including the directory path and full file name. If you did, then what...
Remove Non-AlphaNumeric Characters from String 19 May 2010 | 01:11 am
The function below will allow us to remove a non alphanumeric character from an input string. Be careful though, lengther the string, more time needed to evaluate each string on the sentence. To bad t...
Sum Unique/Distinct Values in Excel 20 Oct 2009 | 07:29 pm
Usually in the sequential database system, we can SUM only unique values in table column by adding all the values from SELECT DISTINCT query result only. Based on the same principle, we can also creat...
Excel Extract Cell Comments 19 Jun 2009 | 07:11 pm
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 usin...
How to get an Acronym using Excel VBA? 17 Jun 2009 | 07:25 pm
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(...
Get Position of Last Column Containing Data with Excel VBA 13 Jun 2009 | 03:38 pm
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 E...
Find the Last Day of any Month 9 Jun 2009 | 03:42 pm
Simple Microsoft Excel formula to find the last day of any given month. ' =DATE(YEAR(A1),MONTH(A1)+1,0) ' Posts Related to Find the Last Day of any MonthHow to create Excel function/formula?This is th...
Schedules to Refresh Data Automatically using VBA Macro 9 Jun 2009 | 04:02 am
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 … ...
Excel VBA Add Set of Worksheets Automatically 8 Jun 2009 | 02:53 pm
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 … Contin...
