Column letter Equivalent of Column Number in Excel
Version Compatibility: Visual Basic 6, Visual Basic 5
I've seen two methods already posted dealing with this issue. Here's how I've done it. I don't know if there's any performance penalty without testing the different methods. But, for whatever it's worth, I think mine's a little easier to read.
Instructions: Copy the declarations and code below and paste directly into your VB project.