Category: Excel
-
Trim Function
This is to remove excess characters from a string. It can be enhanced with options or changed depending if you want spaces or not etc. Function fixchar(s As Variant) As Variant Dim a, b, i As Integer fixchar = “” If Len(s) = 0 Then Exit Function For i = 1 To Len(s) b =…
-
Excel Conditional Formatting
I’m always forgetting the syntax and also here’s some tricks. How to highlight cells based on another cell’s value in Excel 2011 – Ask Different Format cell color based on value in another sheet and cell – Stack Overflow Conditional format cells based on match in another sheet – Stack Overflow
-
Excel VLOOKUP with Multiple Criteria
How to VLOOKUP with Multiple Criteria Using INDEX and MATCH in Excel
-
Directory Tree Builder Add-In for Excel
Directory Tree Builder Add-In for Excel. DirTree will create a tree-like hierarchical list of all the folders and (optionally) files contained within a specified directory. When you load the Add-In, an item with the caption Build Directory Tree is created on your Tools menu. When you click that item, the Directory Tree Configuration screen, described…
-
Reverse String
Function revstr(s As String) As String ‘ ‘ revstr Macro ‘ revstr = “” If s = “” Then Exit Function For j = Len(s) To 1 Step -1 revstr = revstr & Mid(s, j, 1) Next End Function