Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.33 seconds.

  1. Replies
    1
    Views
    7

    Re: Sumif between visible cells only

    Have a look here https://www.mrexcel.com/forum/excel-questions/995780-sumif-visible-cells-only.html
  2. Replies
    2
    Views
    13

    Re: If then statement failing

    Hi & welcome to MrExcel.
    How about
    If Range("B2") = "" Then
  3. Replies
    1
    Views
    7

    Re: Nested IF(ISNUMBER(SEARCH Question-HELP!

    Hi & welcome to MrExcel.
    You have brackets in the wrong place & are missing a closing ", try
    =IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection...
  4. Replies
    1
    Views
    15

    Re: Some VBA to beat a repetitive task

    How about
    Sub alanlambden()
    Dim Fname As String, Txt As String
    Dim Wbk As Workbook

    Fname = Application.GetOpenFilename
    If Fname = "False" Then Exit Sub
    Set Wbk =...
  5. Re: Data Extraction multiple Sheets & Multiple Cells

    I should think so, the best way to find out, is to try it.
  6. Replies
    8
    Views
    55

    Re: VBA Userform Combobox color validation?

    A further thought, there is no need for the flag, it can be done like
    a = Sheets("SEARCH").Range("CODES").Value
    With CreateObject("scripting.dictionary")
    For i = 2 To UBound(a, 1)
    ...
  7. Replies
    1
    Views
    11

    Re: Problem handling a run-time 91

    I always use a range valrable when using .Find, as you can easily test to see if it was found
    Dim Fnd As Range
    Set Fnd = lastname.Find(searchInput, , , xlWhole, , , False, , False)
    If...
  8. Replies
    11
    Views
    106

    Re: FALSE instead of null in cell

    Only as long as it works, I could easily have missed something.
  9. Replies
    11
    Views
    106

    Re: FALSE instead of null in cell

    It replaces all of your code.
  10. Re: The extract range has a miising or invalid field name

    How about
    Sub HotLanta()
    Dim Ary As Variant
    Dim i As Long, j As Long
    Dim Ws As Worksheet
    Dim Fnd As Range

    Set Ws = ActiveSheet
    Ary = Array("Feature",...
  11. Thread: Switch

    by Fluff
    Replies
    2
    Views
    17

    Re: Switch

    With switch you don't need a lookup table, so as long as the criteria never change, it's fine. But if your criteria are likely to change, then you would have to modify the formula every time.
  12. Replies
    11
    Views
    106

    Re: FALSE instead of null in cell

    If I understand correctly, you can just do
    Sub trial()
    With Sheets("Sheet1")
    If .Range("E6") = 12 Then
    .Range("E6").Value = ""
    .Range("E3").Value =...
  13. Re: VBA code to automatically save pdf file and also without displaying it

    Duplicate https://www.mrexcel.com/forum/excel-questions/1113041-vba-fill-word-template-save-pdf.html

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps...
  14. Replies
    9
    Views
    40

    Re: Concat and decimal reduction

    You would need to change both the , to a ; for your system.
  15. Re: matching and returning values from different ranges

    Have a look at index/match
    https://exceljet.net/index-and-match
  16. Replies
    2
    Views
    16

    Re: Conditional hiding of many text boxes

    Can put the name of the textbox in F4:F225 next to it's value?
    Also you said the values & textboxes are on different sheets, but your code is looking at the same sheet. If they are on different...
  17. Replies
    9
    Views
    40

    Re: Concat and decimal reduction

    Not for me it doesn't

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  18. Replies
    8
    Views
    55

    Re: VBA Userform Combobox color validation?

    My pleasure & thanks for the feedback
  19. Replies
    9
    Views
    40

    Re: Concat and decimal reduction

    How about
    =CONCAT(ROUND(J2+G2+D2/A2*100,2)," %")

    But not sure why you don't just format the cell as Percentage, rather than turning it into text
  20. Replies
    8
    Views
    55

    Re: VBA Userform Combobox color validation?

    Absolutely no problem
    We've all been there :(

    Ok, how about
    Dim Flg As Boolean

    a = Sheets("SEARCH").Range("CODES").Value
    With CreateObject("scripting.dictionary")
    ...
  21. Replies
    8
    Views
    55

    Re: VBA Userform Combobox color validation?

    My apologies if you have taken my post the wrong, it was not meant like that, hence the winking emoji.

    Please bear in mind that we cannot see your workbook, nor do we know exactly what you are...
  22. Replies
    2
    Views
    39

    Re: Vlookup with multiple conditions

    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...
  23. Replies
    5
    Views
    76

    Re: How do I approach this?

    How about a countifs
    =COUNTIFS(B:B,"Yes",K:K,O$3)
  24. Replies
    3
    Views
    36

    Re: Help on search formula with continued text

    How about
    =SEARCH("Term1 ",A1&" ")
  25. Replies
    8
    Views
    55

    Re: VBA Userform Combobox color validation?

    Yup.
    Explain what you are trying to do, rather than just posting non-working code in the hope that one of us is a mind reader. ;)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4