-
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
- 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
- excel vba if number
Popular Searches
Monthly Archives: June 2008
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
How to create Excel function/formula?
This is the reason why the power of Excel when combined with VBA is almost limitless. When we can’t found any Excel function that suite our need, we can built it easily using Excel VBA. If Excel macro or SUB … Continue reading