This is good if you like to use statements like Range("A1") instead of cells(1,1).
So, for example ColLetter(1) = A, ColLetter(2) = b, ... , ColLetter(100) = CV, etc.
3) ColLetter(column number) => passes back column Letter.
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
sure, it's neat to do though.
Here's another way, good for 2 billion columns (Excel 2050)
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Easy one
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks