-
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
- load excel file from other file
- automatically deleting filtered cells in excel
- excel macros to create formulas
- day formulas excel macro
- load open box using vba
- formula to find row in excell cell
- excel 2010 auto start
- maro codes for input box for data entry
- find and count data 0 to 9 in excel
- last row with data with excel vba
Popular Searches
Monthly Archives: October 2008
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
18 Comments
Check If Excel Workbook is Already Open or Not
In my case, I work a lot with transferring data from current Excel Workbook to another Excel Workbook, and to be able to do that, of course I need to make sure whether the destination Workbook is already open or … Continue reading
How To Find Row Position of a Particular Text
Sometimes in Excel, we need to find the row position of a particular text, maybe to be able to paste certain of data right below the corresponding text or else. Very useful if we have an Excel Worksheet Template that … Continue reading
Posted in Cells and Range
Tagged excel macro find row, excel macro find text, excel macro find text in cell, excel vba find, excel VBA find row, excel vba find row containing text, excel vba find text, excel vba macro, find excel vba, find in excel vba, find row position, find row vba, vba find row, vba macro find
14 Comments
Select All Cells With Formula In It
Let say we want to distinguish between ordinary cells and cells with formula in it, so we give a special background color to the cells with formula. For doing it manually is time consuming, especially on Excel Worksheet with large … Continue reading
Posted in Cells and Range
Tagged cell with formula, excel special cells, macro code, vba macro
6 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
10 Comments