Search:

Type: Posts; User: kelly mort; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Yes!!!!

    You did it again :bow::bow:

    You have really opened my eyes to what VBA can do.
  2. Replies
    16
    Views
    5,610

    Re: Excel VBA Barcode Generator

    Great, I was able to play around it and got it accessible by my scanner. 1.5, 25 worked for me.

    So if my guess is correct, then the 3rd and 3rd arguments are for the position of the object.

    Few...
  3. Re: Ranking Code Amendment With System Reserved Numbers -vba

    You are very intelligent!!!

    Very great.

    Another issue I observed is that when I have two same ranks, like 1st, 1st, the next rank is still recorded as 2nd.

    Meanwhile, that's the third. Is...
  4. Re: QR code to load a static barcode control on a worksheet

    So from series of trials, this is how the code is looking like.



    Sub setQR()
    'Updated by Extendoffice 2018/8/22
    Dim xSRg As Range
    Dim xRRg As Range
    Dim xObjOLE As OLEObject
    On Error Resume...
  5. Re: QR code to load a static barcode control on a worksheet

    Bump.

    Still needs help with this please
  6. Replies
    16
    Views
    5,610

    Re: Excel VBA Barcode Generator

    Hello, Tetra201,

    Your code is very cute. It is pointing to exactly what I am trying to achieve.

    One down side is, the bars become very small that my scanner can't pick them up unless I...
  7. Replies
    34
    Views
    45,774

    Re: "Code128" barcode generator in VBA - version 2

    Hi, so I have the workbook sample and it is working cool. One thing I need will be to be able to place the code at a given location than its current location-i don't know which line will do that.
    ...
  8. QR code to load a static barcode control on a worksheet

    I have this code here, to create qr code. It's doing well getting the code.

    But I am thinking of having a pre-created barcode control, where I only run the code to load the control instead of...
  9. Re: Ranking Code Amendment With System Reserved Numbers -vba

    One more issue, I tested the code with all cells being filled. Then I just tried it on data with some blanks and this line was not able to be processed.



    arz(i) = WorksheetFunction.Large(arb,...
  10. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Perfectly done. I am very grateful for the time and energy you put into this for me. :bow::bow::bow:

    So that I don't come back wakeing this post again one day, please lecture me on these two lines...
  11. Re: ENC file problem- don't know how to open it

    Oops. Thanks
  12. ENC file problem- don't know how to open it

    A friend sent me a file to open for him. The file extension has now become like this:

    Book1.docx.nakw

    From his end, he inserted a flash drive into his system and all his files got the new...
  13. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Great!!!

    You are unstoppable, Akuini.

    Very brilliant.

    This line:
  14. Re: Ranking Code Amendment With System Reserved Numbers -vba

    The problem is, it ranks all of them together.

    But from the table I posted, all X labeled data are ranked differently.

    That's seen from R2 upwards from post #20
  15. Re: Ranking Code Amendment With System Reserved Numbers -vba

    <tbody>

    C
    D
    E
    F
    G
    H
    I
    J
  16. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Hello Akuini,

    There was one thing I forgot to mention during my last requirements:

    From the original code I posted, column C was used to uniquely rank the items.

    So the data is sorted by...
  17. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Oh my GOODNESS!!!!

    you are too much, Akuini

    Very fast and smooth
    Thanks so much, I am very grateful
  18. Re: Ranking Code Amendment With System Reserved Numbers -vba

    When I run it I get runtime error 1004

    Unable to get the Large property of the worksheetFunction class

    Then when I went to debug, the value for "i" inside arz(i) was 6.

    One thing to point...
  19. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Yes I still need this part.

    I sorted just to help me do the manual ranking for the test post.
  20. Re: Ranking Code Amendment With System Reserved Numbers -vba

    <tbody>
    N1
    N2
    N3
    N4
    N5
    N6
    N7
    N8
    N9
  21. Re: Ranking Code Amendment With System Reserved Numbers -vba

    N1 N2 N3 N4 N5 N6 N7 N8 N9 N10 TOT INP1 R1 R2 R3 R4 R5 RNK6 RNK7 RNK8 RNK9 RNK10 RNKTOT INPUT2
    98 92 86 80 74 68 ...
  22. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Okay cool. However, I have a few concerns:

    1. Is there a way to make the code work without sorting column A at all? Because it may be hard to get all my columns sorted that way from the original...
  23. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Yes all integers
  24. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Cross posted at:

    https://www.excelforum.com/excel-programming-vba-macros/1294938-ranking-code-amendment-with-system-reserved-numbers-vba.html

    Reason:
    No response after three days
  25. Re: Ranking Code Amendment With System Reserved Numbers -vba

    Bump.

    Still need help with this , please
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4