+ Reply to Thread
Results 1 to 8 of 8

Putting formula and drag down

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Putting formula and drag down

    Hi.
    I'm trying a formula in "H2", but the code is giving error
    Please Login or Register  to view this content.
    Last edited by marreco; 05-15-2012 at 01:53 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Putting formula and drag down

    In VBA you have to use the English function names

    Please Login or Register  to view this content.
    You might also need to replace the ; delimiters with , - I am not sure about this but try both and report back for my info please.
    Last edited by Bob Phillips; 05-15-2012 at 11:02 AM.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Putting formula and drag down

    or maybe use Formulalocal instead of Formula.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Putting formula and drag down

    And you need to double up on quotes

    Please Login or Register  to view this content.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Putting formula and drag down

    btw yes you need commas instead of semicolons.

  6. #6
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Putting formula and drag down

    I do not know why but still gives the same error.

    Run-time error '1004 ':
    Error application definition or object definition

    so that part is yellow, see:
    Please Login or Register  to view this content.

  7. #7
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Putting formula and drag down

    Did you try commas as I suggested?

    Please Login or Register  to view this content.

  8. #8
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: Putting formula and drag down

    ok, I modified and it worked!

    Thank you!

+ 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