Results 1 to 9 of 9

Thread: ConvertFromulaToVBA

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    ConvertFromulaToVBA

    Hello,

    For now I am using formula in column Q6 to down, for checking result are in Range T6:AG8000, against combinations within Range B6:11010.

    I would like and will be grateful if possible, please if some master can convert formula into VBA.

    Here below the file attached with examples.

    Regards,
    Moti
    Attached Files Attached Files

  2. #2
    Lively Member
    Join Date
    May 2021
    Posts
    96

    Re: ConvertFromulaToVBA

    I tried checking the ZIP file, but Windows says it's an invalid compressed file.

    That said, you can easily 'convert' a worksheet formula into VBA by either using the Application.WorksheetFunction method, or the Application.Evaluate method.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    Re: ConvertFromulaToVBA

    Hello Dan_W, I have reduced the file size and uploaded again, can you download it?

    Regards,
    Moti
    Attached Files Attached Files

  4. #4

    Re: ConvertFromulaToVBA

    Is there a specific reason you are looking to convert the formula into VBA, and are you seeking assistance with resolving the issue related to the compressed file?

  5. #5

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    Re: ConvertFromulaToVBA

    Quote Originally Posted by Pictwrigo View Post
    Is there a specific reason you are looking to convert the formula into VBA, and are you seeking assistance with resolving the issue related to the compressed file?
    Hello Pictwrigo, you would have seen I want to check result are in columns T:AG against combinations are in the columns B:O as this is an example there is few data.

    If you multiply B:O column combinations data 375000 rows & result in column 4500 formula take lot of time to finish.

    If this can convert into VBA will perform quicker that is what I believe.

    Regards,
    Moti

  6. #6
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,525

    Re: ConvertFromulaToVBA

    Nobody can use your uploaded zip-file since it's corrupted due to Forum-Issues during that time-period.
    You'd have to upload it anew.

    That said:
    Without knowing WHICH Formila you want to replace, and the Comparison-Logic behind it, I don't think a VBA-Code can "outrun" a Worksheet-Formula
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  7. #7

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    Re: ConvertFromulaToVBA

    Quote Originally Posted by Zvoni View Post
    Nobody can use your uploaded zip-file since it's corrupted due to Forum-Issues during that time-period.
    You'd have to upload it anew.

    That said:
    Without knowing WHICH Formila you want to replace, and the Comparison-Logic behind it, I don't think a VBA-Code can "outrun" a Worksheet-Formula
    Hello Zvoni, Please try to download this one, formula and the expected results are sown in it.

    Kind Regards,
    Moti
    Attached Files Attached Files

  8. #8
    PowerPoster Zvoni's Avatar
    Join Date
    Sep 2012
    Location
    To the moon and then left
    Posts
    4,525

    Re: ConvertFromulaToVBA

    What in blazes is that Formula in Column Q supposed to do?!?!?

    I'm not going to research what it does.

    Describe what the Formula is doing, and maybe we can derive an algorithm for it
    Last edited by Zvoni; Tomorrow at 31:69 PM.
    ----------------------------------------------------------------------------------------

    One System to rule them all, One Code to find them,
    One IDE to bring them all, and to the Framework bind them,
    in the Land of Redmond, where the Windows lie
    ---------------------------------------------------------------------------------
    People call me crazy because i'm jumping out of perfectly fine airplanes.
    ---------------------------------------------------------------------------------
    Code is like a joke: If you have to explain it, it's bad

  9. #9

    Thread Starter
    New Member
    Join Date
    Jun 2023
    Posts
    14

    Re: ConvertFromulaToVBA

    Quote Originally Posted by Zvoni View Post
    What in blazes is that Formula in Column Q supposed to do?!?!?

    I'm not going to research what it does.

    Describe what the Formula is doing, and maybe we can derive an algorithm for it
    Zvoni, you are correct I will try to explain if not clear please ask again.

    In the column B:C there is football play combinations and right side in the column T:AG there is historical football results. So basically formula is checking How much match is found with each combination?

    To make it simpler live the B:C data as it is, just check 1 result is In range T6:AG6 and delete all T7:AG4505 result. You will see it will show you matching result against all combinations.

    As you keep adding results will very basically formula is multi result checker.

    Hope this help.

    Kind Regards,
    Moti

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width