-
Recent Posts
- Excel VBA: Empty Clipboard Excel
- How to Get a Full File Path in Excel?
- Remove Non-AlphaNumeric Characters from String
- Sum Unique/Distinct Values in Excel
- Excel Extract Cell Comments
- How to get an Acronym using Excel VBA?
- Get Position of Last Column Containing Data with Excel VBA
- Find the Last Day of any Month
- Schedules to Refresh Data Automatically using VBA Macro
- Excel VBA Add Set of Worksheets Automatically
Recent Searches
- Progress Bar During Refresh of External Data in Excel
- macro display last row of data
- excel sheet hide vb
- vba LastRowWithData
- excel 2010 open files macro
- find last row with data in excel
- count nr of columens excel macro
- macro show last line of data
- excel vba last day of the month
- excel UDF split non numeric characters
Popular Searches
Author Archives: Admin
Excel VBA: Empty Clipboard Excel
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 save the … Continue reading
Posted in Excel VBA Function
35 Comments
How to Get a Full File Path in Excel?
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 … Continue reading
Posted in Excel Formula, Excel VBA Function, Workbook and Worksheet
Tagged file path, fullname, Function
34 Comments
Remove Non-AlphaNumeric Characters from String
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 that I don’t have any idea … Continue reading
Sum Unique/Distinct Values in Excel
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 create a simple VBA function in … Continue reading
Posted in Excel VBA Function
40 Comments
How to get an Acronym using Excel VBA?
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 acronym, array, excel macro example, excel vba example, left, split, ucase
35 Comments
Get Position of Last Column Containing Data with Excel VBA
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
Excel Extract Cell Comments
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 →