Click here to Skip to main content
15,668,517 members
Articles / Productivity Apps and Services / Microsoft Office / Microsoft Excel

Tagged as


5 bookmarked

Converting Column Numbers to Range Headers and Vice Versa

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
2 Sep 2020CPOL
Two functions to help manipulate Excel sheets with VBA by converting Column Header letters to 1 based numbers and back
Utility functions to get the column number (1 based) in Excel from the letter headers or the letters from the 1 based number


Daily Counts


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By
Database Developer self interested
United Kingdom United Kingdom
I have been a software developer for about 20 years, mostly in small IT department that means you do all the roles all the time from 1st line support to 3rd line diagnostics and help authoring. To be fair, I don't do enough of the later which in turn causes way too much of the former with new staff always ready to show you how unintuitive your interfaces are!

I generally consider myself a "data plumber" with the majority of my work in back end SQL. If I could rule the world by writing a SPROC I would....

New definition of Stoicism: Someone who start a career in I.T. and still has a career in I.T. after 20 years!

Comments and Discussions