Results 1 to 20 of 24

Thread: get column letter

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Gibbo,

    I agree with shades, you can just use Cells and not even bother using the column letter.

    Dim C As Long
     For C = 2 To 20 Step 2
       Range(Cells(4, C), Cells(34, C + 1)).Sort Key1:=Cells(4, C), Header:=xlNo
     Next
    Though named ranges is a good way to do it as well.
    Matt
    Last edited by Aussiebear; 04-08-2023 at 05:06 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
  •