Consulting

Results 1 to 3 of 3

Thread: Solved: Find Last column

  1. #1
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location

    Solved: Find Last column

    I can't figure out why this line of code won't work? I already declared LastColumn as Long

    [VBA]LastColumn = Cells(1, 100).End(xlLeft).Column[/VBA]

  2. #2
    Knowledge Base Approver
    The King of Overkill!
    VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Djblois,

    xlToLeft


    Matt

  3. #3
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location
    thank you

Posting Permissions

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