Results 1 to 3 of 3

Add New Row with formulaes

Threaded View

  1. #1
    Forum Contributor bengaluru's Avatar
    Join Date
    06-10-2005
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    150

    Add New Row with formulaes

    Hello friends

    I have a "Add new Row" button that adds a new row at the top of the sheet. My code is

    Private Sub CommandButton1_Click()
    
    Rows("14:14").Select
    Selection.Insert Shift:=x1Down
    
    End Sub
    Although it adds a new row at the top, it does not add the formulaes in some of the cells - even the simple ones such as "=B16"

    What do I have to do to get the formulaes as well in the new row ?

    Thanks for your help.
    Last edited by bengaluru; 09-08-2011 at 02:43 PM.

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