+ Reply to Thread
Results 1 to 3 of 3

Adding Rows to a worksheet

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Adding Rows to a worksheet

    Hi,

    I have the following piece of code which adds a user entered number of rows to a worksheet. However, as I already have one row in existance (which it copies x times) I'd like it to take one off the total entered by the user as it means I end up with one row more than is required.

    Im sure it's simple enough and i've tried my best to work it out on my own,but just end up with some runtime errors....(I set i to -1 but im guessing that's a schoolboy error!)

    Please Login or Register  to view this content.
    Last edited by Barking_Mad; 06-22-2010 at 09:24 AM.

  2. #2
    Forum Contributor pierre08's Avatar
    Join Date
    02-16-2010
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    166

    Re: Adding Rows to a worksheet

    if i did understand what you need i think you shoold add this:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Re: Adding Rows to a worksheet

    Lovely stuff, spot on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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