Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.82 seconds.

  1. Re: Run-time error 438. Object doesn't support this property or method.

    Each computer stores .exd files when activex controls have been used on it. If the version of the control information stored in the exd file is not the same as the current installed version of the...
  2. Re: Run-time error 438. Object doesn't support this property or method.

    This is one of the issues with using activex controls on worksheets. Unless everyone is on exactly the same version of Office and Windows (including the same updates) you can get incompatibilities...
  3. Re: The extract range has a miising or invalid field name

    You could simply run 4 advanced filters within an On Error Resume Next, each extracting one column.
  4. Replies
    5
    Views
    109

    Re: Ampersands Appearing in Formulas

    It's new functionality and it gets rolled out gradually, depending on what update channel you're on.
  5. Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

    I haven't looked at that workbook in detail so I can't say. I'm sure you'll figure it out though. :)
  6. Replies
    2
    Views
    33

    Re: Runs on one but not another

    It shouldn't run on your machine either since you have Option Explicit at the top of the code module. I can't see any good reason for a type mismatch there since a date should be coercible to a...
  7. Re: SUMIF Formula where Excel is treating the Date criteria as Text

    Glad to help. :)
  8. Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

    Have a look at this one for instance: https://www.contextures.com/exceldatepicker.html
  9. 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?
  10. 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...
  11. 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.
  12. 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?
  13. 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...
  14. Replies
    5
    Views
    109

    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...
  15. 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?
  16. 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).
  17. 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.
  18. 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
  19. 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. :)
  20. 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
  21. Replies
    2
    Views
    30

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

    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.
  23. Replies
    12
    Views
    884

    Re: What is early binding and late binding

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

    Re: What is early binding and late binding

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

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