Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.30 seconds.

  1. Re: Still unable to locate the case of a invalid sort

    Missed the Next i
    With ThisWorkbook.Worksheets("SKPLIST")
    .Range("A4").EntireRow.Insert Shift:=xlDown
    .Range("A4:F4").Borders.Weight = xlThin
    For i = 0 To...
  2. Re: Still unable to locate the case of a invalid sort

    Ok, replace this
    ControlsArr = Array(Me.ComboBox1, Me.ComboBox2, Me.ComboBox3, Me.ComboBox4, Me.ComboBox5, Me.ComboBox6)

    With ThisWorkbook.Worksheets("SKPLIST")
    ...
  3. Replies
    3
    Views
    80

    Re: Using commonvariables

    You're welcome & thanks for the feedback
  4. Re: Need help with an IF/THEN formula to include AND in addition to a date lookup

    You're welcome & thanks for the feedback
  5. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    In my opinion there is no such thing as a "Best" option, just different ways of doing things.
    What is "Best" depends on your exact situation, your knowledge (especially if you want to be able to...
  6. Re: Can't get Workbook/sheet reference to work in my function

    You're welcome & thanks for the feedback.
  7. Re: Still unable to locate the case of a invalid sort

    Didn't notice that part.
    Are all the controls numerical values, or just some?
  8. Replies
    5
    Views
    127

    Re: How to compare two set of list with formula

    You're welcome
  9. Thread: Excel Code Help

    by Fluff
    Replies
    10
    Views
    117

    Re: Excel Code Help

    In that case best use MickG's code.
  10. Re: Need help with an IF/THEN formula to include AND in addition to a date lookup

    How about
    =IF(AND(YEAR(A1)=2019,B1="Med"),C1,"")
  11. Re: Delete ROW based on another sheet list value

    Ok, how about
    Sub MMarius()
    Dim Ary As Variant
    Dim i As Long

    With Sheets("sheet2")
    Ary = Application.Transpose(.Range("A1", .Range("A" & Rows.Count).End(xlUp)).Value)
    End...
  12. Replies
    5
    Views
    127

    Re: How to compare two set of list with formula

    The problem is that col J does not have values like 16 pcs, it is simply formatted to show that.
    Therefore try
    =IF(I2="","",IF(SUMPRODUCT(($E$2:$E$8=I2)*($F$2:$F$8=J2))=1,"Match", "Miss"))
  13. Replies
    3
    Views
    58

    Re: Check if value exists in a range

    You're welcome & thanks for the feedback
  14. Replies
    3
    Views
    80

    Re: Using commonvariables

    Rather than using variables, just assign the values directly from the lblInfo_Click event like
    Private Sub lblInfo_Click()
    With GelBMRProperties
    .lblGelCodeR.Caption =...
  15. Re: Delete ROW based on another sheet list value

    How about
    Sub MMarius()
    Dim Ary As Variant

    With Sheets("sheet2")
    Ary = Application.Transpose(.Range("A1", .Range("A" & Rows.Count).End(xlUp)).Value2)
    End With
    With...
  16. Thread: Excel Code Help

    by Fluff
    Replies
    10
    Views
    117

    Re: Excel Code Help

    Can you have a situation like this

    <b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse;...
  17. Replies
    3
    Views
    58

    Re: Check if value exists in a range

    How about
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Fnd As Range

    If Target.CountLarge > 1 Then Exit Sub
    If Target.Value = "" Then Exit Sub
    If Target.Column = 1...
  18. Re: Used Concatenate To Create Formula But Cannot Get It To Do What I need

    You're welcome & thanks for the feedback
  19. Re: Used Concatenate To Create Formula But Cannot Get It To Do What I need

    Try
    =INDIRECT("'SCORING BY MONTH'!"&V5)
  20. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    Thanks for that Mark, didn't realise it was limited in that way.
  21. Re: Performance: What is the best "method" to pull data from Several WorkBooks using VBA

    As far as I know, the PowerQuery add-in works with 2010
  22. Thread: Unique name list

    by Fluff
    Replies
    7
    Views
    69

    Re: Unique name list

    In that case it needs to be
    =IFERROR(INDEX(Q$11000:Q$14000,MATCH(0,INDEX(COUNTIF(BG$2:BG2,Q$11000:Q$14000),0),0)),"")
  23. Thread: Excel Code Help

    by Fluff
    Replies
    10
    Views
    117

    Re: Excel Code Help

    Another option
    Sub hazmat()
    Dim Rw As Long

    Rw = Application.Min(Range("C" & Rows.Count).End(xlUp).Row, _
    Range("E" & Rows.Count).End(xlUp).Row, _
    ...
  24. Re: Can't get Workbook/sheet reference to work in my function

    Remove this line from the code
    Dim FromWorkbook As Workbook, ToWorkbook As Workbook
  25. Re: Need help with an IF/THEN formula to include AND in addition to a date lookup

    Hi & welcome to MrExcel.
    Can you explain what you mean by
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4