Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 24 of 24

Thread: get column letter

  1. #21
    VBAX Newbie
    Joined
    Jul 2009
    Posts
    1
    Location
    No the problem doesn't get old. Your code just help me tremendously! Thank you.

    I just used it for a complex dynamic name range creation sub and in case someone else would use it, I gave you the credit for that part of the code.

  2. #22
    MsgBox Split(ActiveCell.Address, "$")(1) works, since the assumption for address is xlA1

  3. #23
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    11-21-2005, 10:16 AM
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  4. #24
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Mr Benson of Schenectady comes to VBAX?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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