+ Reply to Thread
Results 1 to 5 of 5

How do I select a row in VB like this Activecell.rows but in a table

Hybrid View

  1. 05-25-2023, 12:40 PM #1
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,565

    Re: How do I select a row in VB like this Activecell.rows but in a table

    Besides Marvin's solution,
    Insert Row Above Row 5
    ActiveSheet.ListObjects("Table1").ListRows.Add (5)
    from here:
    https://www.thespreadsheetguru.com/b...t-excel-tables
    Experience trumps academics every day of the week and twice on Sunday.
    Reply With QuoteRegister To Reply
  2. 05-25-2023, 12:46 PM #2
    chrispikekerry
    chrispikekerry is offline
    Registered User
    Join Date
    07-15-2022
    Location
    Delta Canada
    MS-Off Ver
    365
    Posts
    73

    Re: How do I select a row in VB like this Activecell.rows but in a table

    jolivanes
    I get this error:
    Attachment 830686


    error02.png
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select cells on both sides of active cell, then select all rows down table with data
    By KCourt in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-19-2021, 07:46 PM
  2. difference in between activecell.activate and activecell.select
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2020, 03:14 AM
  3. [SOLVED] copy rows with activecell value and insert rows after activecell
    By a.hudrea in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-21-2014, 09:05 AM
  4. VBA select the entire Table row below ActiveCell
    By kaseyleigh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2014, 09:05 AM
  5. How to select activecell
    By excel_vb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2010, 03:17 AM
  6. select activecell and following
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2009, 08:07 AM
  7. [SOLVED] select range next to activecell
    By lookin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2006, 03:10 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1