Results 1 to 6 of 6

Add/subtract rows and Name all from a variable range

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Talking Add/subtract rows and Name all from a variable range

    OK, hopefully this is the last question from me for today:

    1. For the attached, for RoyUK's code, Add a Row needs to add ONLY to the bottom of the blue range and push the lower red range down. I can't figure out the syntax for how to limit it to just that range. Right now, the code looks for the first empty row and adds there.

    2. Also for the column A of that same growing/shrinking blue range, I added a Named Range (WONum) so that I can use those column A numbers as a Data Validation List in other sheets of the workbook. Right now, the named range isn't capturing the entire blue range as I add and delete rows.

    3. I read a post about adding/deleting rows from named ranges. Would naming the blue range make the code easier?

    4. The blue range should be unlocked, but all the red cells should be locked. Since the blue range is changing, the cell locking/unlocking needs to change also.

    Many problems on this same sheet, but this template will be used for many others. I appreciate if anyone can help fix this.

    Respectfully,

    Lost
    Attached Files Attached Files
    Last edited by leaning; 06-21-2011 at 11:18 AM. Reason: Solved!

Thread Information

Users Browsing this Thread

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

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