+ Reply to Thread
Results 1 to 8 of 8

Problem Using FormulaLocal in VBA

  1. 07-11-2013, 01:32 PM #1
    QcSylvanio
    QcSylvanio is offline
    Registered User
    Join Date
    10-03-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Problem Using FormulaLocal in VBA

    Hi everybody,

    I'm having some issues lately using Formula and FormulaLocal in my VB code. I been looking around but nothing really helped me so far.

    Sometimes it work, sometimes it doesnt work and I dont understand why because I use the same logic.


    Here is an exemple :

    Please Login or Register  to view this content.
    I have fews other like this that are working so I dont get why this one isnt.

    I have tried with FormulaLocal and also Formula in english.

    Any help on this please?

    Thanks guys!
    Reply With QuoteRegister To Reply
  2. 07-11-2013, 01:49 PM #2
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Problem Using FormulaLocal in VBA

    Thats a lot of "" are you sure they are in there correctly? Do you need an ampersand to concatenate some of the formula arguments?

    I didn't test but the "" look off.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."
    Reply With QuoteRegister To Reply
  3. 07-11-2013, 02:04 PM #3
    QcSylvanio
    QcSylvanio is offline
    Registered User
    Join Date
    10-03-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Problem Using FormulaLocal in VBA

    Hi there,

    I can guarantee you they are okay

    I double checked more than once and even try to retype it.
    Reply With QuoteRegister To Reply
  4. 07-11-2013, 02:05 PM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,659

    Re: Problem Using FormulaLocal in VBA

    Quote Originally Posted by QcSylvanio View Post
    Hi everybody,

    I'm having some issues lately using Formula and FormulaLocal in my VB code. I been looking around but nothing really helped me so far.

    Sometimes it work, sometimes it doesnt work and I dont understand why because I use the same logic.


    Here is an exemple :

    Please Login or Register  to view this content.
    I have fews other like this that are working so I dont get why this one isnt.

    I have tried with FormulaLocal and also Formula in english.

    Any help on this please?

    Thanks guys!
    Misspelled .FormulaLocal in the example code.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  5. 07-11-2013, 02:31 PM #5
    QcSylvanio
    QcSylvanio is offline
    Registered User
    Join Date
    10-03-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Problem Using FormulaLocal in VBA

    Right.

    But this is okay in my files. Sorry about this.
    Last edited by QcSylvanio; 07-11-2013 at 03:06 PM.
    Reply With QuoteRegister To Reply
  6. 07-11-2013, 04:01 PM #6
    JosephP
    JosephP is offline
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Problem Using FormulaLocal in VBA

    perhaps you can post the actual code ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to
    Reply With QuoteRegister To Reply
  7. 07-11-2013, 04:35 PM #7
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,659

    Re: Problem Using FormulaLocal in VBA

    Here's a shorter formula for what it's worth.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 07-12-2013, 09:38 AM #8
    QcSylvanio
    QcSylvanio is offline
    Registered User
    Join Date
    10-03-2012
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Problem Using FormulaLocal in VBA

    Thank you AlphaFrog for this shorter formula.

    Index is a new one for me!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1