Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds; generated 2 minute(s) ago.

  1. Re: 'Range' of object '_Global' failed ---runtime error 1004

    If I select the part with borders I get 168.4589 in N42 which is correct for where I have the data.
    Check that your values are numbers & not text.
  2. Re: 'Range' of object '_Global' failed ---runtime error 1004

    You need to delete your original macro, or change the name of one of them.
  3. Re: 'Range' of object '_Global' failed ---runtime error 1004

    Hi & welcome to MrExcel.
    How about
    Sub FindMax()
    '
    Dim MaxCell As Range, zoomRng As Range, maxvalue As Variant

    ActiveSheet.Cells.Interior.Color = xlNone 'Clear out old highlight colors first
    ...
  4. Re: VBA Cascading Listboxes 4 columns unique values only

    How about
    Dim UfDic As Object

    Private Sub lstRegion_Click()
    Me.lstProducts.Clear
    Me.lstRegulated.Clear
    Me.LstCountry.List = UfDic(Me.LstRegion.Value).keys
    End Sub

    Private Sub...
  5. Replies
    10
    Views
    81

    Re: COUNTIF for a word within a phrase

    If I understand correctly, how about
    =COUNTIF(J:J,"*Transfer*")
  6. Replies
    8
    Views
    216

    Re: Dynamic ListBox for an invoice

    How about
    Private Sub lstInvoices_Click()
    Dim Ary As Variant, Nary As Variant
    Dim r As Long, c As Long, nr As Long

    With Sheets("PurchaseRawData")
    Ary = .Range("B3:R" &...
  7. Re: reference multiple tables within search range

    You're welcome & thanks for the feedback.
  8. Replies
    17
    Views
    294

    Re: ComboBox BackColor change on value

    Glad you got it sorted & thanks for the feedback
  9. Re: VBA Search for any of three items, return whole row or rows of matching data.

    The "On Error GoTo 0" simply resets the error handler back to the default and needs to be kept.

    Do you have any blank rows in your data?
  10. Replies
    5
    Views
    125

    Re: Multiple Column Combibox

    Select the combobox & then in the properties window change ColumnCount to 2
  11. Re: VBA: Specific number in a serie-of-numbers in a cell equals a color

    How about
    Sub Infine()
    Dim Cl As Range

    For Each Cl In Range("C2", Range("C" & Rows.Count).End(xlUp))
    If Len(Cl.Value) > 3 Then
    If IsNumeric(Right(Left(Cl, Len(Cl) -...
  12. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    Glad it's sorted & thanks for the feedback
  13. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    In that case can you please explain everything that you need, as I am not willing to continue guessing what may or may not work.
  14. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    To return those values you can change the formula to
    =(CODE(LEFT(VLOOKUP($A7,'CHRISTMAS GIFT SHOP'!$A:$E,3,FALSE)))-63)*10
  15. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    Did you actually try the formula I suggested? It will return the same values that you have shown.
  16. Re: Runtime error 91 Object Variable or with block variable not set

    For me it was primarily from helping people here.
    You get to see all sorts of problems that you may not come across in you rline of work.
    Also you get to see how other people resolve those problems.
  17. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    I don't understand why a wildcard would help to change the 1 to 30 or the 2 to 60.
    Can you post some sample data along with the expected result & explain how you get that result.
  18. Thread: Formula advice

    by Fluff
    Replies
    14
    Views
    144

    Re: Formula advice

    If the returned value always starts with a capital letter, try
    =CODE(LEFT(VLOOKUP($A7,'CHRISTMAS GIFT SHOP'!$A:$E,3,FALSE)))-64
  19. Re: Produce a new list based on values in a range

    You're wlecome & thanks for the feedback
  20. Re: Produce a new list based on values in a range

    How about

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  21. Replies
    5
    Views
    60

    Re: return certain value

    You're welcome & thanks for the feedback
  22. Replies
    5
    Views
    125

    Re: Multiple Column Combibox

    Have you set the combobox columncount property to 2?
  23. Re: Autofilter table depending on the date value from different sheet MACRO VBA

    If you are filtering on dates try
    ActiveSheet.ListObjects("Table8").Range.AutoFilter Field:=1, Criteria1:=CDate(Sheets("Sheet1").Range("B1"))or
    ActiveSheet.ListObjects("Table8").Range.AutoFilter...
  24. Re: Keep Top 5 Lines of Filtered Range - Delete the rest

    Glad to help & thanks for the feedback
  25. Replies
    17
    Views
    294

    Re: ComboBox BackColor change on value

    OK, because it's case sensitive, try
    With Me.ComboBox1
    Select Case LCase(.Value)
    Case "terminal box"
    .BackColor = &HFF00&
    Case "none"
    ...
Results 1 to 25 of 148
Page 1 of 6 1 2 3 4