Browse by Tags

This code will list all the formulas in the selection in the Immediate Window. Sub ListFormulas()         Dim rCell As Range         If TypeName(Selection) = "Range" Then         For Each rCell In Selection.Cells             Debug.Print String(4, " ") & rCell.Address(0, 0), rCell.Formula         Next [...] Read More...

Hi everyone, The release date of Office 2010 is closing in and with this new version we’ll have a new programming challenge. Office 2010 comes in a 32 bit and a 64 bit version. Especially API function declarations need to be adjusted for the 64 bit environment. We’ll have to change a declaration like this one:     Private [...] Read More...

Hi All, Many users (including customers of mine) have experienced trouble with two recent security updates by Microsoft, see: http://support.microsoft.com/kb/973475 and http://support.microsoft.com/kb/973593 There seem to be two hotfixes to this problem: KB973475 Excel 2003 hotfix package : http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=978908&kbln=en-us KB973593 Excel 2007 hotfix package : http://support.microsoft.com/default.aspx?scid=kb;EN-US;978522 If you experience problems with...

Many of my spreadsheets use Excel 2003 Commandbars for application control. Having loaded these spreadsheets into Excel 2007, I see my commandbars presented on the Add-In tab of the Ribbon. I’m a late starter with Excel 2007 ribbons, but I guess it’s time to move. I’ve found that the various guides on the Internet tend to throw you [...] Read More...

This started off by helping myself to Dick’s code in ‘Removing Spaces from File Names’ (http://www.dailydoseofexcel.com/archives/2009/11/12/removing-spaces-from-file-names/) but quickly evolved to meet my own needs. First, was the requirement to replace a certain text string by another. I added 3 parameters to the subroutine (Dirname, ReplaceWhat, and ReplaceBy). Also evident was that some files had [...] Read More...

Andy commented: There's one other similar conundrum that has always intrigued me: What 3-letter suffix can be added to the most letters of the alphabet to make valid 4-letter words? True word nerds just use their brains and knowledge of language. Guys like me use VBA. Warning: This code takes forever to run. Run it at your [...] Read More...

I was thinking about passwords recently. How I got from thinking about passwords to this post is a long and boring story, so I'll spare you the mental chain. The end of that chain was this thought: I can take the letters F and R and put a vowel in between them [...] Read More...

Two recent instances required transferring data from one array to another. One was a solution to speed up the use of COUNTIF for each element in a large range testing against another large range. In the process I had to build several building blocks including a replacement for the native Excel TRANSPOSE function, [...] Read More...