Excel VBA to reverse a Pivot Table. You can always trust finding Excel stuff if you use J-Walk as part of the search.
I first found out about John Walkenback from his books. He, without question, has the best books on Excel. Back when books only were made from dead trees I judged books by how much real information versus fluff. He wins outright. His books now are available in paper format or electronically. He also has a […]
I was working in Excel matching some strings and they were not matching even though they looked the same on the screen. Well it turns out that there are different kinds of dashes! A normal dash you use is the keyboard is the minus sign on your keyboard. But there are others that can get […]
I had written my own but it had a bug. Then I found this code below on this site. It gives credit to John Walkenbach who writes, bar none, the best books on Excel. And the following function returns nothing more than the number of elements you get when you cut a string according to […]
Excel 2010 doesn’t have an XOR function. The newer versions do. I have needed this form of logic a couple of times recently and I found a good tip here. XOR works like this. A B Result 1 1 0 1 0 1 0 1 1 0 0 0 So, if you don’t have an […]
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 = […]