Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.29 seconds.

  1. Re: Run-time error1004 in code when searching through large data set

    In that case I'm not sure why you would get an error. Transpose should be able to handle that amount without any problems.
  2. Re: Run-time error1004 in code when searching through large data set

    If you put this just before the line that fails, what does the message box say?
    Msgbox .Count
    Also what version of Xl are you using?
  3. Replies
    4
    Views
    26

    Re: Calculation just doesnt add up

    Glad we could help & thanks for the feedback
  4. Replies
    7
    Views
    37

    Re: VLOOKUP 255 cell limit workaround - help

    Vlookup is limited to the number of characters in a cell, not the number of cells
  5. Replies
    4
    Views
    26

    Re: Calculation just doesnt add up

    You need to put brackets around the addition.
    Multiplication is done first followed by addition.
  6. Thread: Check Mark shown

    by Fluff
    Replies
    2
    Views
    18

    Re: Check Mark shown

    Do you mean a little green triangle in the top left of the cell?
  7. Replies
    21
    Views
    226

    Re: Sum in selected cell

    It currently rounds up to the nearest 0.5, if you don't want that use.

    Cl.Offset(, 3).Value = Cl.Offset(, 7) * 1.1 / (Sp(0) * Sp(1)) / IIf(Cl.Offset(, 12) > 17, 5000, 7000)
  8. Re: Find And Replace in Multi excel files with multi worksheets

    Not that I'm aware of, your code works for me with that update.
    Did you try what I suggested in post#10?
    If so what were the results?
  9. Replies
    8
    Views
    104

    Re: Minimum of the multiple dates for a Product

    Expanding on Peter's formula
    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  10. Re: Comparing updates of a register presented in colums

    My pleasure.
  11. Re: VBA If And Or query on strings containing times

    What if you try
    Mid(MyCell.Text, 4, 2)
  12. Re: Comparing updates of a register presented in colums

    For reference there's a site here that will translate formulae, which I used to translate Toadstool's formulae https://en.excel-translator.de/translator/
  13. Replies
    8
    Views
    51

    Re: Slightly tricky conditional formatting

    If you select B5:B18 and D5:E18 then use
    =$E5="YES"
    that should format all three columns if col E=YES
  14. Replies
    8
    Views
    51

    Re: Slightly tricky conditional formatting

    What formula are you using for the CF?
  15. Re: Comparing updates of a register presented in colums

    For A2
    =SI(Latest!A2="";"";SI(ESNOD(COINCIDIR(Latest!A2;Lastweek!A:A;0));"New "&Latest!A2;""))
    B2
    =SI(Lastweek!A2="";"";SI(ESNOD(COINCIDIR(Lastweek!A2;Latest!A:A;0));"Dropped "&Lastweek!A2;""))...
  16. Replies
    8
    Views
    51

    Re: Slightly tricky conditional formatting

    Based on your OP using CF, how about
    Dim eCell As Range
    For Each eCell In [E5:E18]
    eCell.Offset(, -3).Font.Color = eCell.DisplayFormat.Font.Color
    eCell.Offset(, -1).Font.Color...
  17. Replies
    21
    Views
    226

    Re: Sum in selected cell

    Ok, how about
    Sub leaper1981()
    Dim Cl As Range
    Dim Sp As Variant
    For Each Cl In Range("A5", Range("A" & Rows.Count).End(xlUp))
    If IsNumeric(Cl.Offset(, 2)) And Cl.Offset(, 2) <>...
  18. Re: Look for B1 value in another workbook, then see if somewhere in that row the value matches A2

    You're welcome & thanks for the feedback
  19. Re: Add automatically new sheet names to a combobox

    Glad we could help & thanks for the feedback
  20. Re: Subscript out of range, constant not recognised weirdness. Pls Help! :-(

    You're welcome & thanks for the feedback
  21. Replies
    5
    Views
    94

    Re: Variable in Ranges

    Do you mean that you have other columns that are not getting sorted along with col A?
  22. Re: Add automatically new sheet names to a combobox

    You can get the new sheets added when created like

    Private Sub CommandButton1_Click()
    Sheets.Add(, Sheets(Sheets.Count)).Name = "HELP!"
    Me.ComboBox1.List = GetList
    End Sub


    Private Sub...
  23. Re: Most common number that follows a specified value in a list

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
    Per forum rules, posts of a duplicate nature will be...
  24. Replies
    3
    Views
    88

    Re: Hide Data in Running Total Pivot

    musukoll
    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13...
  25. Replies
    6
    Views
    119

    Re: Help with a VBA Formula

    You're welcome & thanks for the feedback
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4