Converting Column Numbers to Range Headers and Vice Versa

Darren G441

Rate me:

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

Views

Daily Counts

License

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

Written By

Darren G441

Database Developer self interested

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!

Converting Column Numbers to Range Headers and Vice Versa

Views

License

Comments and Discussions