Find out if formula is absolute

  • Re: Find out if formula is absolute


    I was not able to duplicate the problem you mention when running the code. To double-check, this is the macro you're using?


    Best Regards,
    Luke M
    =======
    "A little knowledge is a dangerous thing."

  • Re: Find out if formula is absolute


    Hi Luke,


    yes, basically I used same method - Application.ConvertFormula



    Let's say some cells of the range contain formula like this:


    Code
    =SUMIF('INPUT TRAD'!$F:$F,BNL!$D$20,'INPUT TRAD'!$B:$B)


    Then those cells after running the macro change result to #VALUE error.

  • Re: Find out if formula is absolute


    Hi mikerickson,


    same result whether I loop through areas or cells.
    Cannot figure out why, I guess I need to find a workaround.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!