-
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
- 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
- how to search a hidden row and return the result on the the row before it hidden
Popular Searches
Tag Archives: Excel VBA Function
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
How To Find the Last Row That Contain Data in Excel?
UPDATE June 13, 2008: Another alternative way to find the last row with data : Function LastRow() As Long Dim ix As Long ix = ActiveSheet.UsedRange.Row – 1 + ActiveSheet.UsedRange.Rows.Count LastRow = ix End Function I did a simple test, … Continue reading
Posted in Excel VBA Function
Tagged excel 2007 last row, excel last row, excel last row with data, excel vba find last row, excel vba find last row with data, excel vba formula, Excel VBA Function, excel vba last row, excel vba last row with data, excel vba lastrow, find last row excel vba, last row excel vba, last row in Excel, last row with data, vba excel last row, VBA last row with data
27 Comments
How to ceiling a decimal number in Excel?
Ceiling, or changing a specific decimal number into become its upper number, for example if we ceiling 3.25 we will got 4, or if we ceiling 2.75 then we will got 3 as a result. To get a result like … Continue reading
Posted in Excel VBA Function
Tagged ceiling vba, excel vba ceiling, Excel VBA Function, vba ceil, vba ceiling, vba ceiling function
5 Comments