-
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
- how to place the cursor in next cell which has data-vba
- 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
Popular Searches
Category Archives: Workbook and Worksheet
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
Schedules to Refresh Data Automatically using VBA Macro
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
Excel VBA Add Set of Worksheets Automatically
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 excel vba add worksheet, excel vba worksheet, excel worksheet
33 Comments
VBA Delete Excel Rows Based on Certain Date
Let say I have a bunch of formatted data in my Excel sheet, and in Column A I have a dates. Then I wanna filter all the data base on certain date, for example 1 Jan 2009, and delete all … Continue reading
Number of Cells/Rows/Columns With Formula
A few weeks ago I received this question from someone called LS: Hi I want to write a macro that counts the following – Number of cells with formula – Number of Rows with formula – Number of Columns with … Continue reading
Automatically Run an Excel Macro
Auto run macro excel… Do you want to run an excel macros automatically when the file is open or close? Microsoft Excel provide us the opportunity to run a macro automatically every time we open or close the excel workbook file, using … Continue reading
Convert Excel Column Number into Column Name
Update: Sorter version of the VBA function: Function Number2Char(c As Integer) As String Number2Char = Split(Cells(1, c).Address, “$”)(1) End Function Courtesy of The Plaid Cow. OR Function Number2Char(ByVal vNumber) Dim addr As String If vNumber 256 Then Exit Function addr … Continue reading
Posted in Workbook and Worksheet
Tagged column name excel, column number into column name, excel column name, excel macro column name, excel macro column number, excel vba column name, excel vba column number, excel vba columns, excel vba get column name, how to get column name in excel, VBA column name, vba excel column name
35 Comments