Results 1 to 3 of 3

Thread: Add blank rows to table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2018
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Add blank rows to table

    Hi, I'm trying to get a table to always have a fixed number of blank rows in a given column, this is to make sure that my helper table always contains all the data available. I think it should be something like a macro that counts the blank cells in a given columns and adds a column if the count is lower than a set number, and loops the process until the count is good. I know very little about VBA coding so I searched a couple of forums but couldn't find anything...

    Thanks in advance
    Chuckaroo

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    4,057
    Post Thanks / Like
    Mentioned
    73 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Add blank rows to table

    How is the incorrect number of rows causing a problem with the Helper table ?
    Is the table a structured table (created with INSERT \ TABLE) ?

  3. #3
    New Member
    Join Date
    Jul 2018
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Add blank rows to table

    Hi, sorry for the delay, my project was on hold for a while. The helper column automatically fills with dates that are used to reference other formulas, but I want my formulas to work without the user having to manually expand the helper table.

    Thanks,
    Chuckarou

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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