+ Reply to Thread
Results 1 to 4 of 4

go outside of a qury table and to the right

  1. #1
    Forum Contributor
    Join Date
    12-02-2010
    Location
    USA
    MS-Off Ver
    Excel 365 and sometimes excel 2013
    Posts
    172

    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
    1,176

    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
    USA
    MS-Off Ver
    Excel 365 and sometimes excel 2013
    Posts
    172

    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.

  4. #4
    Forum Contributor
    Join Date
    12-02-2010
    Location
    USA
    MS-Off Ver
    Excel 365 and sometimes excel 2013
    Posts
    172

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

    i'm using another technique so may not need this now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move data from 1 table to another table, then clear the original table
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2019, 06:06 PM
  2. Replies: 9
    Last Post: 02-01-2019, 07:10 AM
  3. Replies: 1
    Last Post: 03-25-2018, 04:16 PM
  4. Crosstab table to pivot table to plain table exceeds Excel row limit
    By jjsilva in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2017, 11:43 PM
  5. Macro to fill 1st table with info from 2nd table. 2nd table search with 2 conditions
    By Ribeiro.JD in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-17-2016, 02:03 PM
  6. HELP for Excel Qury in SQL codes
    By Naghman in forum Excel General
    Replies: 1
    Last Post: 03-14-2014, 09:29 AM
  7. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM

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