Insert row on button position
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Insert row on button position

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    How do I insert a row using a macro button that insert the row beneath the row that the macro button is touching?

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Curious....why not just put the Insert Row toolbar button up on the toolbar, or even on its own floating toolbar?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi --
    can i ask what your trying to do?

    i love the question but can not work how this will be usable, the button will need to be moved about, can i suggest that the row is inserted below the active cell??? so that you select the row any column abd run the script so the row is inserted, thus no need for moving a button about all the time and that would be some complex script...

    If thisis of in sure i can write some VBA code.

    HTH
    Rdgs
    ==========
    Jack

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's a sales tracking tool to be used by very non-excel oriented people all over the country. They need to enter rows based on the number of sales and they need a tool to facilitate this under several different salespersons sections. (i.e., sales rep A consists of rows 4:8 initially, sales rep B consists of rows 10:14, etc... more rows need to be added to the specific rep that exceeds four sales a month.)

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any suggestions?

  6. #6
    New Member
    Join Date
    Feb 2002
    Location
    Washington State
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe a stupid suggestion, but why not do a workbook with a seperate sheet for each salesman, then as long as they don't have more than 65,536 sales a month there shouldn't be any need to add a row.

    Rick

  7. #7
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This is a sold orders entry page that populates an individual reps own sheet.

    Any ideas on how to do this?

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any suggestions?

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-21 05:33, Q45 wrote:
    Any suggestions?
    I'd suggest an Access Solution for this one

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try this:

    CommandButton1.BottomRightCell.Offset(1).EntireRow.Insert

    Regards,

    Juan Pablo González
    http://www.juanpg.com

User Tag List

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
  •  

 

 
DMCA.com