Consulting

Results 1 to 20 of 24

Thread: get column letter

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Expert
    Joined
    Jan 2005
    Posts
    574
    Location

    get column letter

    Can anyone tell me if there is an easier way to get the column letter of the active cell than the method im using below

    (Row is there just incase this method is of use to others, im only interested in the easiest method of getting the column letter)

    cheers

    gibbo

    Sub Location()
    Col = Split(ActiveCell(1).Address(1, 0), "$")(0)
    'Row = Split(ActiveCell(1).Address(1, 0), "$")(1)
    MsgBox Col' & Row
    End Sub
    Last edited by Aussiebear; 04-08-2023 at 05:05 AM. Reason: Adjusted the code tags

Posting Permissions

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