+ Reply to Thread
Results 1 to 3 of 3

Problem using formulas within macro + problem with defined name.

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Problem using formulas within macro + problem with defined name.

    Hi
    Im having 2 problems with this following formula

    Please Login or Register  to view this content.
    First problem is that for some reason it wont let me use defined name for the last IF statement. At the moment its like this
    Please Login or Register  to view this content.
    But it should look loke this.
    Please Login or Register  to view this content.


    So all in all it would look like this:
    Please Login or Register  to view this content.
    Second problem is that Im trying to use macro to populate this formula in column AM. So far I have not had any success. I have tried the 2 following macros with no luck.


    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    I have attached the xls ofcourse. Any help woud be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Problem using formulas within macro + problem with defined name.

    In your first attempt you're using FormulaR1C1 but A1 referencing.

    The second attempt would work if you were using a standard UK regional setting - ie comma as delimiter rather than semi-colon.

    If you're using a semi-colon delimiter it will not as FormulaLocal utilises the Regional syntax rather than US-centric syntax per Formula

    Given the above I'd suggest you adopt an A1 reference style with US-centric syntax:

    Please Login or Register  to view this content.
    Note: I've not reviewed the performance of the formula itself.

  3. #3
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Re: Problem using formulas within macro + problem with defined name.

    Thank you!
    Works like a charm! You are a star!

+ 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