Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.89 seconds.

  1. Re: .attachment.add - 440 - Property is read-only

    :biggrin: Glad to help.
  2. Re: .attachment.add - 440 - Property is read-only

    Remove the = sign. It's just:


    msg.attachments.add filepath
  3. Re: Countif formula returning the same results for entire data range that start with a prefix of < >

    Glad to help. :biggrin:
  4. Replies
    16
    Views
    250

    Re: More =IF formula issues

    It's possible the cell format was text when the TRUE was entered initially. Subsequently just changing the format to General would not convert the content to a Boolean, but retyping the value again...
  5. Re: Countif formula returning the same results for entire data range that start with a prefix of < >

    What exactly is an "owner name"? The formula I posted will not ignore text following a < or > sign - the = sign will treat those as literal text rather than as comparison operators.
  6. Re: Countif formula returning the same results for entire data range that start with a prefix of < >

    So does:

    =COUNTIF(Open!E:E,"="&Sheet2!E13)

    not work? If not, in what way?
  7. Re: Countif formula returning the same results for entire data range that start with a prefix of < >

    Perhaps you could post the actual formula you are using?
  8. Re: Countif formula returning the same results for entire data range that start with a prefix of < >

    If you want to look for that exact text, use "=>Less than 5 years Old" as the criterion.
  9. Replies
    19
    Views
    354

    Re: #NA error on one System.

    I assume you're trying to use the last populated row? If so, try:

    =HYPERLINK("[Quickly jump to last row using hyperlinks.xlsx]Sheet1!$B$"&LOOKUP(2,1/(B1:B100<>""),ROW(B1:B100))+1,"Hyperlink")
  10. Re: Run Time error 28 - Out of stack space????

    If you change a cell in a Change event, you'll trigger the event again, hence the problem. You need to temporarily disable events:


    Private Sub Worksheet_Change(ByVal Target As Range)

    If...
  11. Replies
    19
    Views
    354

    Re: #NA error on one System.

    Not the same formula, does the same workbook work on one but not the other?

    There is no difference in VLOOKUP (other than performance) in more recent versions of Office.
  12. Re: How to set the start position of a modeless user-form?

    Screenupdating is probably the culprit.
  13. Re: Sorting code brings up 1004 Application-defined or Object Defined Error

    I mean this:


    Sub DataSort()
    Dim wsRes As Worksheet, wsPoi As Worksheet
    Set wsRes = ThisWorkbook.Sheets("Results")
    Set wsPoi = ThisWorkbook.Sheets("Title Points")
    Application.ScreenUpdating =...
  14. Re: How to set the start position of a modeless user-form?

    It works fine for me. Is it the first time that form has been loaded and shown?
  15. Replies
    4
    Views
    74

    Re: IF with more conditions

    Looks like three separate countif formulas to me:

    =IF(AND(COUNTIF($E$2:$E$5;A2);COUNTIF($F$2:$F$5;B2);COUNTIF($G$2:$G$4;C2));"YES";"NO")
  16. Re: VBA clipboard going wrong when File Explorer open

    It's a bug that started in Windows 8 and has persisted in Win10. You should use API calls instead.
  17. Re: can't find the function I created under the WorksheetFunction

    The WorksheetFunction class does not expose functions you create. There wouldn't be much point to it doing so.
  18. Re: Sorting code brings up 1004 Application-defined or Object Defined Error

    You need to clear the sortfields in between.
  19. Re: Run-Time Error 438 Object Doesn't Support this property

    Change the wb.sht1 in Fluff's code to just sht1
  20. Thread: Compile Error

    by RoryA
    Replies
    5
    Views
    122

    Re: Compile Error

    Is there any code in the Workbook_Open event of that workbook?
  21. Re: INDIRECT in COUNTIFS and SUMPRODUCT returing error, despite working when they are the only arguments

    Are you sure the ranges are the same size and shape as the values you are using in INDIRECT?
  22. Replies
    47
    Views
    241,651

    Re: INSERT A SPACE INTO A TEXT VALUE

    That’s an easy change then:

    =A1&" "&a2
  23. Replies
    47
    Views
    241,651

    Re: INSERT A SPACE INTO A TEXT VALUE

    Can you not add the space when combining them initially?
  24. Replies
    7
    Views
    53

    Re: VBA: Highlight header row on Autofilter

    Which version of Excel? I would expect Worksheet_Calculate to work for an autofilter.
  25. Re: list box returns compile error on every alternative saving of a work book

    If I were you I'd replace your listbox with a Form control version and redo the code accordingly. ActiveX controls are flaky at best, especially if you need them to work on different computers.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4