+ Reply to Thread
Results 1 to 2 of 2

Copying formulas via user form

  1. #1
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2007
    Posts
    115

    Copying formulas via user form

    Hi everybody,

    I've created a userform with a cmd button to insert data in a sheet named "DataBase".
    Every time new data is entered, a new row is added in the sheet (this is working great). the problem is that one of the columns as a formula and that formula doesn't "jump" to the next row.

    Am i being clear? Can anyone help me with the code?

    Thanks

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Copying formulas via user form

    Why not just add a line of command to filldown or copy the formula from above? This can be included in the code that you are already using with the cmd button

+ 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