-
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
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
592 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
751 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
902 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
799 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 →