Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.86 seconds.

  1. Replies
    19
    Views
    346

    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")
  2. 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...
  3. Replies
    19
    Views
    346

    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.
  4. Re: How to set the start position of a modeless user-form?

    Screenupdating is probably the culprit.
  5. 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 =...
  6. 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?
  7. 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")
  8. 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.
  9. 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.
  10. Re: Sorting code brings up 1004 Application-defined or Object Defined Error

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

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

    by RoryA
    Replies
    5
    Views
    122

    Re: Compile Error

    Is there any code in the Workbook_Open event of that workbook?
  13. 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?
  14. Replies
    47
    Views
    241,545

    Re: INSERT A SPACE INTO A TEXT VALUE

    That’s an easy change then:

    =A1&" "&a2
  15. Replies
    47
    Views
    241,545

    Re: INSERT A SPACE INTO A TEXT VALUE

    Can you not add the space when combining them initially?
  16. 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.
  17. 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.
  18. Thread: Advanced Filter

    by RoryA
    Replies
    8
    Views
    189

    Re: Advanced Filter

    Select the apparently blank cells in the criteria range and press the Delete key, then try it again.
  19. Thread: Advanced Filter

    by RoryA
    Replies
    8
    Views
    189

    Re: Advanced Filter

    That is a link to an xlsx file, which cannot contain userforms or macros.
  20. Replies
    3
    Views
    178

    Re: Calculating y,m,d not including blanks

    Which "ym" (there are two) and what is the error message?
  21. Thread: Advanced Filter

    by RoryA
    Replies
    8
    Views
    189

    Re: Advanced Filter

    "It doesn't work" really doesn't help us to help you. If you're using it from userforms (first time you've mentioned them and there aren't any in the workbook you posted), how are you doing so? What...
  22. Thread: Advanced Filter

    by RoryA
    Replies
    8
    Views
    189

    Re: Advanced Filter

    What exactly is the problem?
  23. Replies
    4
    Views
    126

    Re: Code for copy rows from sheet2 to cheet1

    Please take a minute to read the forum rules on cross-posting and follow them, especially as you seem to be doing it with every post. Thanks.
  24. Replies
    3
    Views
    178

    Re: Calculating y,m,d not including blanks

    It looks like you should be using:

    =IF([@[BEGIN DATE-MIN ]]<>"",IF(DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y"), DATEDIF([@[BEGIN DATE-MIN ]],TODAY(),"y")&" year,"")&IF(DATEDIF([@[BEGIN DATE-MIN...
  25. Replies
    2
    Views
    113

    Re: Automatically start a function

    That code will run automatically whenever the workbook is activated, assuming you have it in the ThisWorkbook module of the workbook.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4