+ Reply to Thread
Results 1 to 1 of 1

Auto fill from one cell to another from add row button

Hybrid View

newbie4 Auto fill from one cell to... 10-03-2012, 04:31 PM
  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    USA, CA
    MS-Off Ver
    Excel 2007
    Posts
    131

    Auto fill from one cell to another from add row button

    Hi there,

    I am using a add button to drop down rows, however since there are so many add and delete buttons, everytime I insert a row via add button, it changes the row number.

    For example,
    Sub InsertRows()
    Rows("8").Insert Shift:=xlDown
    End Sub
    Sub DeleteRows()
    Rows("8").Delete Shift:=xlDown
    End Sub


    If I put in 5 more like that, it messes up my formatting for the other rows. Is there any way around this?

    Thanks,
    Newb
    Last edited by newbie4; 10-04-2012 at 02:48 PM. Reason: Change of problem

+ Reply to Thread

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