If you want to convert the text to uppercase, use the following code; however, I recommend downloading ASAP Utilities, it has many functionalities, including text conversion. It doesn’t offer source code though. Here’s my code for uppercase conversion:(If you want to convert your text to lowercase, replace Ucase with Lcase function in the code) ‘Will […]
Continue readingRecently, I had the need of printing the data structures of many dbf files. A google search reveled the DBF.COM file that would output dbf file structures, number of records, file name, date of last update, etc. Download this file here: files/DBF.COM (Caution: I downloaded this file from the internet, and I do not make […]
Continue readingIn this short video you can learn how to assign a macro to a button on your toolbar. If this macro is in the personal workbook then you can use it on any workbook.
Continue readingIf you want to count cells in a given range without formulae use this function Function CountNoFormula(rng As Range) As LongDim c As Range On Error GoTo CountNoFormula_Error For Each c In rng If Not c.HasFormula Then CountNoFormula = CountNoFormula + 1 End If Next cCountNoFormula_CleanUpExit: Exit FunctionCountNoFormula_Error: CountNoFormula = CVErr(Err.Number) Resume CountNoFormula_CleanUpExitEnd Function If you want to count cells with formule […]
Continue readingTo calculate the average of n biggest numbers from a list enter this formula with Ctrl + Shift + Enter: =AVERAGE(IF(RANK(yourrange,yourrange)<=n,yourrange,””)) To calculate the average of n smallest numbers from a list enter this formula with Ctrl + Shift + Enter: =AVERAGE(IF(RANK(yourrange,yourrange)>COUNT(yourrange)-n,yourrange,””)) For an example:
Continue reading