+ Reply to Thread
Results 1 to 4 of 4

adding a new row to a table and then inputting the data

  1. #1
    Registered User
    Join Date
    11-16-2018
    Location
    london
    MS-Off Ver
    version 1810
    Posts
    20

    adding a new row to a table and then inputting the data

    i have this code for adding a new row to a table and then inputting the data through an array, however when it gets to the UBound section theres an error. please can you either change the existing code for it to work or offer new code for adding a new row and putting data in there thank you.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: adding a new row to a table and then inputting the data

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 01-01-2019 at 06:16 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    11-16-2018
    Location
    london
    MS-Off Ver
    version 1810
    Posts
    20

    Re: adding a new row to a table and then inputting the data

    thank you!
    However when the top table row is empty (not including headers) it does not input the data into that row, is there anyway that the first set of data can go into the first empty row (after the headers)?

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: adding a new row to a table and then inputting the data

    Quote Originally Posted by Chelsea19 View Post
    thank you!
    However when the top table row is empty (not including headers) it does not input the data into that row, is there anyway that the first set of data can go into the first empty row (after the headers)?
    Headers aside, do you mean the top row is empty but there are filled rows below it?

    Can you provide an example workbook with before and after sheets?

+ 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. Automating Pivot Table after inputting data
    By pigment01 in forum Excel General
    Replies: 1
    Last Post: 05-01-2017, 12:35 PM
  2. Replies: 13
    Last Post: 07-16-2016, 10:53 PM
  3. [SOLVED] Inputting Data on a table from other sheets
    By mikerules in forum Excel General
    Replies: 5
    Last Post: 11-30-2015, 09:01 PM
  4. [SOLVED] Inputting new Headers and pulling data from other tables (same WB) into main table
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-30-2014, 02:38 PM
  5. Replies: 8
    Last Post: 04-28-2014, 01:51 AM
  6. [SOLVED] Button for adding a new line across multiple sheets, inputting data to certain cells
    By jamief in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2014, 08:40 PM
  7. Replies: 1
    Last Post: 06-09-2012, 10:02 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1