Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.88 seconds.

  1. Re: SUMIF Formula where Excel is treating the Date criteria as Text

    That does tend to confirm that the numbers in H are not numbers. What does:

    =SUM(H:H)

    return? 0?
  2. Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

    I mean that you either add the control to your userform when it loads, rather than having it already present (will require more coding), or use a totally different approach, such as a separate...
  3. Re: How to create arrow that grows with size of value

    It could have been made with something like Tableau, but you can create a bar chart in Excel and then just copy and paste an arrow shape onto the chart series to achieve something similar.
  4. Re: SUMIF Formula where Excel is treating the Date criteria as Text

    That would make me think that my first suggestion is the problem. What does:

    =countif(L:L,O6)

    return?
  5. Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

    If you didn't save the file, it would still work on 32 bits. You cannot code round this problem if the control is present when the workbook opens, so if you need to support 64bit versions, either...
  6. Replies
    2
    Views
    53

    Re: Ampersands Appearing in Formulas

    When the @ symbol appears before a function, it's because the function uses implicit intersection, and this doesn't fit with the new dynamic array formulas (@ is actually a replacement for the...
  7. Re: In user subscribed threads there is no display of no(s) of views and replies

    You can't as far as I know. Why is it important?
  8. Re: SUMIF Formula where Excel is treating the Date criteria as Text

    I'd say the more likely cause is that either the numbers in column H are actually text, or the dates really don't match (eg if there's a time portion in one or other).
  9. Re: Worksheet Display Not Updating Through Loop Process

    Probably because the Import procedure turns screenupdating off and doesn't turn it back on, so you'll only get an update when all the code has finished.
  10. Re: Argument not optional problem If Not Intersect Private Sub Worksheet Change

    There should be a comma there, not a full stop:


    If Not Intersect(Target, Range("I8:I32")) Is Nothing Then
  11. Re: Load Exported.UI file on Work book start up

    Believe me, that way is considerably easier than what you are attempting as an alternative. :)
  12. Re: Load Exported.UI file on Work book start up

    You're going about it the wrong way. You should read this: http://www.rondebruin.nl/win/s2/win001.htm
  13. Replies
    2
    Views
    25

    Re: VBA for Sumifs not working

    The last part should be:


    ThisWorkbook.Sheets("First line manager").Cells(z, 1)

    and not:


    ThisWorkbook.Sheets("First line manager"), Cells(z, 1)
  14. Replies
    12
    Views
    838

    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.
  15. Replies
    12
    Views
    838

    Re: What is early binding and late binding

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

    Re: What is early binding and late binding

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

    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.
  18. Replies
    6
    Views
    574

    Re: Microsoft Access 14.0 Object Library

    Why would you attempt to uncheck an Access reference when you are working in Access?
  19. 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))
  20. Replies
    2
    Views
    110

    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.
  21. Replies
    4
    Views
    202

    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
  22. Replies
    12
    Views
    838

    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.
  23. Replies
    2
    Views
    110

    Re: object required error 424

    Remove the .Activate part.
  24. 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...
  25. Replies
    2
    Views
    52

    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)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4