Search:

Type: Posts; User: jolivanes

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    914

    Like DocAElstein suggested. Explain in detail....

    Like DocAElstein suggested. Explain in detail.
    But also:
    In "Sub UnmergeAllCells()" you reference ActiveSheet
    In "Sub UnwrapTextAllCells()" you don't reference any sheet.
    In "Sub...
  2. Replies
    19
    Views
    7,513

    @Admin Kimi is doing better in Singapore. Could...

    @Admin
    Kimi is doing better in Singapore.
    Could not fing anything for him though.
  3. Replies
    19
    Views
    7,513

    ok, thanks for the kind words and we'll leave it...

    ok, thanks for the kind words and we'll leave it at that.
    Keep on "duimen voor Max Verstappen"
  4. Replies
    19
    Views
    7,513

    Indeed. I stand corrected. I guess instead we...

    Indeed. I stand corrected.
    I guess instead we could use Trim
    My apologies snb.
  5. Replies
    19
    Views
    7,513

    I don't know if you tried snb's formula but if...

    I don't know if you tried snb's formula but if you found that it does not work it is because you need to change the semicolon (;) to a comma(,).
    You might also take his counting with a grain of...
  6. You could try this Range("A" &...

    You could try this

    Range("A" & Rows.Count).End(xlUp)(-498).Resize(500,6).Copy Range(H1")
  7. Range(Cells(5,1), Cells(Rows.Count,...

    Range(Cells(5,1), Cells(Rows.Count, "A").End(xlUp)).Resize(,11).Select

    This should replace the two lines of code. Select is very seldom needed and you should see if you can adapt the code.
    Using...
  8. Replies
    3
    Views
    1,172

    The data is the result of the formula, so no, you...

    The data is the result of the formula, so no, you can't
    Clear the values in Columns B and C and use this Formula.

    =IF(OR(B3="",C3=""),"",SUM(B3:C3))
  9. An ugly way of getting there. Cell A1 has the...

    An ugly way of getting there.
    Cell A1 has the starting number
    Cell A2 has the end number
    Cell A3 has the increment
    Column B needs to be empty (free to use)
    Result in cell E2



    Sub...
  10. Have a look here Code for Trim Non-numeric...

    Have a look here

    Code for Trim Non-numeric values..
Results 1 to 10 of 10