While Excel boasts over 450+ functions, sometimes they just donâ t cut it. These built-in functions fall short when you want to automate specific tasks or perform unique calculations in your ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. Now I want to convert it ...