+ Reply to Thread
Results 1 to 3 of 3

go outside of a qury table and to the right

  1. #1
    Forum Contributor
    Join Date
    12-02-2010
    Location
    Denver USA
    MS-Off Ver
    Excel 2013
    Posts
    131

    go outside of a qury table and to the right

    hi, if i am inside a query table and want to go all the way to the right of a row and then another 2 columns to the right because i have adjacent data that is not part of the table, how can i do that in vba? the command below only let's me go to the end of the query table but not outside of it even though there is data there. thx

    Range(Selection, Selection.End(xlToRight)).Select

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    987

    Re: go outside of a qury table and to the right

    Selection.End(xlToRight).Select
    activecell.offset(0,2).select

  3. #3
    Forum Contributor
    Join Date
    12-02-2010
    Location
    Denver USA
    MS-Off Ver
    Excel 2013
    Posts
    131

    Re: go outside of a qury table and to the right

    i guess i didn't explain it correctly above. i want to select all the cells from the first column in the table where my cursor is at all the way to the right of the table and also include the two adjacent columns.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1