Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.87 seconds.

  1. Replies
    12
    Views
    675

    Re: What is early binding and late binding

    The late binding is correct but you would of course need to remove the early bound Public variables.
  2. Replies
    12
    Views
    675

    Re: What is early binding and late binding

    Yes it is, though there is no point for native Access objects like QueryDef.
  3. Replies
    12
    Views
    675

    Re: What is early binding and late binding

    The first two pairs are early binding, the last is late binding (declared as Object).
  4. Replies
    6
    Views
    462

    Re: Microsoft Access 14.0 Object Library

    To be honest, if you can't tell by reading the code, you probably shouldn't be editing it. At any rate, you cannot remove a reference to the host application.
  5. Replies
    6
    Views
    462

    Re: Microsoft Access 14.0 Object Library

    Why would you attempt to uncheck an Access reference when you are working in Access?
  6. Re: Extracting text from a cell when the location is different each time.

    Welcome to the forum.

    Assuming you don't have anyone using 100GB or more, something like this should work:

    =TRIM(MID(" "&E7,SEARCH("GB"," "&E7)-2,4))
  7. Replies
    2
    Views
    109

    Re: object required error 424

    It seems you have subsequently asked this same question elsewhere, so I'll close this to avoid anyone else wasting their time.
  8. Replies
    4
    Views
    197

    Re: Macro not compatablie with Macs

    It's easier to use conditional compilation, in my opinion:


    #If Mac then
    ' do Mac things
    #Else
    ' do Windows things
    #End If
  9. Replies
    12
    Views
    675

    Re: What is early binding and late binding

    Simply put:
    Late binding = declaring obejct variables as Object.
    Early Binding = declaring object variables as a specific type.
  10. Replies
    2
    Views
    109

    Re: object required error 424

    Remove the .Activate part.
  11. Replies
    5
    Views
    67

    Re: PutInClipboard Office 365

    It's actually nothing to do with Office. There's a bug in Windows 8 and later that causes this to happen if you have File Explorer windows open. You should use Windows API calls to put text in the...
  12. Replies
    2
    Views
    51

    Re: Runtime Error 13: Type-Mismatch

    You've declared fDelimiters as an array, but in examples 1 and 2, Delimiters(0) is not an array, it's a string, so this will fail with a type mismatch:


    fDelimiters = Delimiters(0)
  13. Re: .attachment.add - 440 - Property is read-only

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

    Remove the = sign. It's just:


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

    Glad to help. :biggrin:
  16. Replies
    18
    Views
    318

    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...
  17. 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.
  18. 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?
  19. 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?
  20. 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.
  21. Replies
    19
    Views
    373

    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")
  22. 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...
  23. Replies
    19
    Views
    373

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

    Screenupdating is probably the culprit.
  25. 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 =...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4