+ Reply to Thread
Results 1 to 2 of 2

Copy and insert row below within fixed upper limit and dynamic lower limit

  1. #1
    Registered User
    Join Date
    08-15-2015
    Location
    South Africa
    MS-Off Ver
    2010
    Posts
    1

    Copy and insert row below within fixed upper limit and dynamic lower limit

    Hi. I am a VBA novice. I have the following problem.

    I need users to be able to copy current row to an inserted row directly below the active row in a worksheet using a macro.
    However the users may not insert rows above row 11.

    Further the users may not insert rows below StopRowInsert (a Range name for the value of rows before row insertions) row 49-1. Therefore if a user insert a row, the Row() value for the row at row 49 would increase to 50 and 50-1 would be the new lower limit for row insertions.

    Outside rows 9 and the value defined by the Range name StopRowInsert the macro should not insert rows and prompt the user to select a cell in the allowable range.

    The macro I have for the insertion and copy-ing of the row is below.

    Please Login or Register  to view this content.
    How can I add the limits and the user message to the macro?
    Any ideas and suggestions are welcome. Thanks in advance.
    Last edited by JBeaucaire; 08-15-2015 at 10:50 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Registered User
    Join Date
    08-23-2015
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    32

    Re: Copy and insert row below within fixed upper limit and dynamic lower limit

    Firstly, you should protect the sheet to not allowing row insertion anywhere. Once protected:
    Please Login or Register  to view this content.
    Thus, preventing insert a row above 11th row.

    ...row 49-1. Therefore if a user insert a row, the Row() value for the row at row 49 would increase to 50 and 50-1 would be the new lower limit for row insertions.
    Outside rows 9 and the value defined by the Range name...
    You should explain it a little bit less confusing... better yet, clear as water if you want people to exactly understand what you are talking about and help you...
    May the REPUTATION be with me

+ 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. upper and lower limit in charts made dynamic
    By rajasekar93 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-30-2015, 11:07 AM
  2. Finding a value within an upper and lower limit
    By bergii in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 05:05 PM
  3. [SOLVED] I need to creat a IF formula that has a upper and lower limit.
    By jnelson83 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-11-2013, 12:11 PM
  4. [SOLVED] find the lower and upper limit if data is in between on that limit
    By clangeles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2012, 06:18 AM
  5. [SOLVED] IF(AND(COUNT one incident between a lower and upper limit
    By dmad81 in forum Excel General
    Replies: 4
    Last Post: 06-20-2012, 12:01 AM
  6. Upper and lower limit lines on chart
    By Joeschmo5 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-08-2009, 10:09 AM
  7. Count occurence with user defined upper&lower limit.
    By Chan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2006, 12:35 AM

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