Search:

Type: Posts; User: montecarlo2012; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    176

    Re: [VBA] For next require vs for each

    footoo, Thank you Sir for your Answer.
  2. Replies
    2
    Views
    176

    [VBA] For next require vs for each

    Sub D_W()
    Dim X As Range, Y As Range
    For Each X In Range("B3:g3")
    Set Y = Range("J5:Q10").Find(X, LookIn:=xlValues, lookat:=xlWhole)
    ...
  3. Re: [VBA] Changing the range in the code FROM the spreadsheet

    mole999. Moderator. Sir. I am really thankful for the time you spent typing the website you suggested, for some reason wasn’t helpful, I am a beginner on this, so maybe that’s why.
  4. Re: [VBA] Changing the range in the code FROM the spreadsheet

    mole999 thank you for your intervention. Could you "PLEASE" give me the guidelines?. if you don't mind. Thank you Sir.
  5. [VBA] Changing the range in the code FROM the spreadsheet

    Hi Folks.
    The code I am loading here is about to make calculation in the range ("B4:B18") "BUT" now I need to test the code in different ranges, example B4:B10, and after maybe B4:B22 and keep...
  6. Replies
    10
    Views
    396

    Re: VBA A code within a loop

    DanteAmor You are G R E A T, THANK YOU SO MUCH. great lesson. awesome job.
  7. Replies
    10
    Views
    396

    Re: VBA A code within a loop

    DanteAmor, First Thanks for doing this.
    Ok, now talk about the code. Return the right results for only six times, so at this point, the only thing left to do is make it go to the final 17 rows of...
  8. Replies
    10
    Views
    396

    Re: VBA A code within a loop

    Hi, just in case still want to help me, I would like to see at list the average formula working , meaning the average the only thing is doing is
    sum(B3:B20)/17
    sum(B4:B21)/17
    sum(B5:B22)/17 and...
  9. Replies
    10
    Views
    396

    Re: VBA A code within a loop

    DanteAmor, Thank you for your kindness.
    You are the Ninja here and I am the new-bee, so the only thing maybe I can say is; this Coefficient trend lines functions are a long algebra formulas, What...
  10. Replies
    10
    Views
    396

    Re: VBA A code within a loop

    DanteAmor Thank you So much for your input.
    Definitely this structure repeat 155 time the code, the results are not what I expected, supposedly every frame have different results, because the code,...
  11. Replies
    10
    Views
    396

    VBA A code within a loop

    Hi.
    I have a dynamic array at B3:G2650 and in A3:A20 the numbers from 1 to 17.
    The double-code uploaded here return the coefficient trend line results at J3:Q10 respectively in this frame and the...
  12. Replies
    6
    Views
    312

    Re: VBA-macro require a for next loop

    Fluff, Sir. Good Morning.
    Thank you for taking the trouble to help me. I do appreciate it.
    Is working.
    Just in case somebody else are in the same spot I am posting the final results as a...
  13. Replies
    6
    Views
    312

    Re: VBA-macro require a for next loop

    Michael M. Thank you. and Good Morning. The first code work good, now I just tried the rest of my formulas and error occurred. Here it is the rest, I am trying. As a note the $A$3:$A$20 is just the...
  14. Replies
    6
    Views
    312

    VBA-macro require a for next loop

    Hello folks.
    PLEASE, I have a macro, and I see some kind of loop concept to apply here but still thinking, so PLEASE somebody can give me a hand here.


    Sub Coe_fficient_trend_line()...
  15. Re: vba code to get all combinations and permutations IF they equal a cells

    Shg. Thanks a lot!
    No, Sir. I think the best way to describe what I try to do is to say Number Generator with Constraints to Cell Values To Fit My Specific Needs.
    It is not alway the same parity;...
  16. Re: vba code to get all combinations and permutations IF they equal a cells

    Thanks Eric W
    The code don't have to read anything from the worksheet, it is just to populate the four columns, I will try your lines. and I really accept any code all I want is to see the result...
  17. Re: vba code to get all combinations and permutations IF they equal a cells

    Eric W
    https://www.mrexcel.com/forum/images/statusicon/user-offline.png
    MrExcel MVP Thank You, So much.
    Sir I replace the line you said ► Call CombinationsNP(Array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9),...
  18. vba code to get all combinations and permutations IF they equal a cells

    Hello folks
    I have been trying to work around this code, I need some hands on here, Please.
    I am trying to generate all possible combinations and permutations possible from the set of numbers from...
  19. Re: VBA - Wrong results for a for next loop.

    Sorry, False Alarm, I found the mistake. Thanks.
  20. VBA - Wrong results for a for next loop.

    Hello.
    This code do not give me any error return; but do not give me the right results either.
    I am trying to get the total of oranges sold only, on "C1". My data Fruit's names A, and quantity...
  21. Re: vba Odd's and Even"s Array Count If

    THANK YOU SIR. You are really Nice, Thank you for your time. work perfect, I See you highlight the changes, wow. I hope you have a great day.
  22. Re: vba Odd's and Even"s Array Count If

    Thank you Fluff (MrExcel MVP).
    Is really Nice from you to give me this code. Important lesson I got here, first I try to change the result locations, so when I see Ary(r, 7) my Visual Logic thought...
  23. Re: vba Odd's and Even"s Array Count If

    Thank you, Rick.
    Yes I need to see the code.
    Its the not the Destination, It's the journey
    I really learn more from the code, the logic behind, the transformation from English to VBA is what...
  24. vba Odd's and Even"s Array Count If

    Hello.
    I have a dynamic array B2:G2600 (6 columns), on Col "M" would like to see how many odd numbers there are in the rows, and on Col "N" the even numbers.
    So I workout first with the macro...
  25. Replies
    9
    Views
    338

    Re: VBA to Separate Values

    Rick Rothstein Thanks. Your interventions always are a real enlightening
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4