+ Reply to Thread
Results 1 to 4 of 4

What table row am I on?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    What table row am I on?

    My cursor is resting on a cell in a column of a table that contains names of students.
    I want to create a new row in a table just below the cell/row my cursor is in.
    IF I know the TABLE row my cursor is on I can just use .ListRows.add Position=X, where X = the row my cursor is on plus 1.
    But how do I find the table row my cursor is on?

    Presently I get the row I am on and subtract the row that the header row range is on, but I suspect there must be a direct means!

    Thank-you-

  2. #2
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: What table row am I on?

    hi brucemc777,


    you may try this,
    if the code helped you, please add reputation to me "*"

    Please Login or Register  to view this content.
    1. Thank those who have helped you by clicking the Star * below the post.
    2. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Sincerely,
    Farid

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Re: What table row am I on?

    Interesting, and thank-you Farid!
    It appears I overthought my problem when a simple solution was at hand ...

    Yes, this entirely solves what I need to do.
    I still am on the hunt for something simpler than what I came up with that neatly returns what row of the dang table I am on!

  4. #4
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: What table row am I on?

    hi brucemc77,

    Thanks for the reputation

+ 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. [SOLVED] Adding a row in a table corrupts formula in a summary table (2nd table)
    By How How in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2015, 02:35 PM
  2. Replies: 1
    Last Post: 07-29-2015, 05:19 PM
  3. Replies: 1
    Last Post: 07-29-2015, 05:15 PM
  4. [SOLVED] Summary table updated from source table. Source table held in a different workbook
    By dma1976 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-22-2013, 11:36 AM
  5. Replies: 0
    Last Post: 07-02-2013, 11:30 AM
  6. [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
  7. [SOLVED] PIVOT TABLE - Summary Table into a Databasae Table.
    By sansk_23 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2005, 03:06 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