Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Get the Letter Value of a Colm from activecell.column?

    i have some code that lands me in a certain colm. How can i get the Column letter, from my activecell location?


    ie : activecell.column =1 is col A

    ?

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Try

    ColLetter = Mid(ActiveCell.Address, 2, 1)

    ActiveCell.Address returns the address in $A$! format, therefore you need to look at positio 2

    Hope this is what you want

    MTB

  3. #3
    Join Date
    Oct 2003
    Posts
    311
    Perrrrrfect,


    Tnks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •