MUO on MSN

Learning REDUCE in Excel completely changed how I use spreadsheets

REDUCE allows you to iterate through your data, building your result step-by-step, in the same way a loop operates in a ...
Ars Technica

Accessing Excel function within VBA

Is it possible to access Excel's various mathematical functions (specifically NORMSINV) from within VBA. I can sort of do what I want just by setting the value of a cell to a string like ...
Ars Technica

Need help converting Sub to Function (Excel VBA)

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. <BR><BR>Now I want to convert ...