+ Reply to Thread
Results 1 to 3 of 3

Inserting a variable amount of Rows

  1. #1
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Inserting a variable amount of Rows

    Hello all,

    I'm trying to insert an amount of blank rows pending a count variable, but I'm not sure what the code would be. Here is what I've got so far.

    Please Login or Register  to view this content.
    Instead of using the last two lines of code, I would like to use a line of code that inserts a number of blank rows pending my count variable.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Inserting a variable amount of Rows

    Please Login or Register  to view this content.
    The 'x' represents the number of rows to insert...

  3. #3
    Forum Contributor
    Join Date
    02-20-2017
    Location
    Indiana
    MS-Off Ver
    2016
    Posts
    101

    Re: Inserting a variable amount of Rows

    This worked. Thanks!

+ 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] Positioning data below variable amount of rows
    By RSa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2017, 02:56 PM
  2. Replies: 2
    Last Post: 06-06-2013, 11:14 PM
  3. cut and paste a variable amount of rows onto other workbooks.
    By bopsgtir in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 08:06 PM
  4. [SOLVED] Transpose rows to columns: variable amount of colums and corresponding values
    By Browser in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-10-2012, 10:40 AM
  5. Inserting variable amount rows between rows
    By marko3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2011, 01:39 AM
  6. Replies: 1
    Last Post: 05-13-2010, 09:50 AM
  7. Macro for Sorting a Variable amount of Rows
    By stepheng2383 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2009, 07:32 PM

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