-
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
Category Archives: Excel VBA Function
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
Move Cursor To One Cell Below Last Row With Data
Ever want to paste some data into new empty cell after the last cell with data in certain column? Then take a look at this simple macro. ‘first, select cell in the first row of that column, like A1, K1, … Continue reading
Finding Cell with Minimum/Maximum Value in Active Worksheet
Let say we want to find position of cell containing the minimum/maximum value in current/active Excel worksheet, and then after we found the cell, we will change the cell format to make it stand out before other cells. The logic … Continue reading
Posted in Excel VBA Function, Workbook and Worksheet
Tagged cell function, excel formula, excel macro, excel tutorial, excel vba formula, Excel VBA Function, excel vba max, excel vba max value, excel vba max value in column, excel vba maximum value, excel vba minimum, learn excel, macro cell, maximum cell value, minimum cell value, vba cell, vba excel, vba macro, vba minimum
1,062 Comments
How To Open Excel File Using Macro
Imagine this condition; We are in the middle of doing something using Excel VBA macro, then we want the macro to automatically show the File Open dialog box to make us (user) able to choose another Excel file to be … Continue reading
Posted in Excel VBA Function
Tagged Dialog Box, excel macro open excel file, excel macro open file, excel macro to open a file, excel open file macro, excel vba open file, macro excel open file, macro open file, macro to open a file, macro to open excel file, Open File, open file macro, open file macro excel, vba macro open file
1,184 Comments