When Excel functions are not enough
BoldCodes BoldCodes is here to help (BoldCodes.com or Bold.Codes), even though I doubt it, I mean the fact that you cannot do your task in...
Excel Limits
Worksheet and workbook specifications and limits For more limits of VBA inside Excel, check out http://BoldCodes.com/?DevID=26CFPFO4LB Feature Maximum limit Open workbooks Limited by available memory...
Count Unique
A question by a colleague on how to count number of unique items in a column made me realize, I don't have that here.
So here...
Cell formats 0.0\% and 0.0%;(0.0%)
We needed a way to force Excel to show the % next to a number without dividing it by 100 You know, when you format...
When Excel tells you to go get some life
This is what happens when you spend too much time in Excel Go have a break and get some life...
DayName
Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only...
Shades of gray
We need this to be documented s8mewhere So, here it is...