Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 3.87 seconds.

  1. Re: Public Functions run for no apparent reason

    As I was composing this question I thought "You dummy, why don't you see what Google has to say?" and as you might expect the answer is there and it's that Public functions are run anytime a recalc...
  2. Public Functions run for no apparent reason

    I have 3 Public Functions in a workbook that run for no apparent reason. The declarations of the functions look like this:

    Public Function MyFunction(v As String) As String
    They do not have...
  3. Replies
    2
    Views
    433

    Re: [RESOLVED] Applescript

    I apologize for forgetting to mark this as Resolved.

    I don't believe that you can create an Applescript that will directly open your Google calendar from the dock, but you can create an app from...
  4. Replies
    2
    Views
    433

    [RESOLVED] Applescript

    In macOS is it possible to write an Applescript that will open my Google calendar?
  5. Re: [RESOLVED] Get row number of the row that's at the top of the window

    ActiveWindow.visiblerange.Row
  6. [RESOLVED] Get row number of the row that's at the top of the window

    Let's say I have a worksheet with 1000 records, none of which are hidden, and visually I see that row 18 is at the top of the window. How can I use VBA to return 18?
  7. Re: [RESOLVED] A question for Kaiser (Northern California) members

    I'm sorry that I didn't mention that I got what I needed from the KP digital app as Steve uggested.
  8. Re: When is a String not a string?

    Thank you. While not exactly what I wound up doing it did remind me of a technique where the worksheet columns values are copied to Variable arrays and the processing is done within those arrays....
  9. Re: When is a String not a string?

    Well I found a simple fix that allows it to run correctly


    If ws1.Cells(lngRow, "BF") = .Cells(lngRowD, "M").Text Then

    but it takes eight minutes!
  10. [RESOLVED] When is a String not a string?

    I'm using Excel 2019 and I have a workbook where In Sheet1 column BF is formatted as Text and in another sheet column M is also formatted as Text.

    I'm trying to compare what's in BF with what's...
  11. [RESOLVED] A question for Kaiser (Northern California) members

    How do I download a copy of my Kaiser COVID vaccination cared to my iPhone?
  12. Re: [RESOLVED] Possible patters of a 4 digit number

    Does that dll exist under Windows XP.? That's where my old VB6 is but it doesn't show up in my References.
  13. Re: Possible patters of a 4 digit number

    Thanks for your help.
  14. Re: Possible patters of a 4 digit number

    Yes you are correct, BBA should be in the list and so should ABB! That would make 6 (3 * 2) patterns.
  15. Re: Possible patters of a 4 digit number

    For 4 digit numbers I have the feeling that there are 24 (4 * 3 * 2) patterns starting with
    AAAA
    AAAB
    BAAA
  16. Re: Possible patters of a 4 digit number

    In those terms the patterns for a 3 digit number are:
    AAA
    AAB
    BAA
    ABC
  17. Re: Possible patters of a 4 digit number

    Sorry, my fault; I'm looking for a pattern of three numbers and I'm using 1, 2 and 3 to represent those numbers. So yes, 100 is the same pattern as 211, but so is 622, 955, 033, etcetera and I'm only...
  18. Re: Possible patters of a 4 digit number

    For three digit numbers maybe I should have said that the four patterns are
    All digits are the same
    The left 2 digits are the same but the 3rd digit is different
    The right 2 digits are the same...
  19. [RESOLVED] Possible patters of a 4 digit number

    I've tried combination and permutation calculators but perhaps because I don't know how to express what I want, I haven't gotten the answer I need. For example with a three digit number there are...
  20. Re: Excel 2019 - Prevent Visual Basic from taking focus

    Update: I know that it used to happen but I can't reproduce it now. Maybe it is because I trned Snap off.
  21. Excel 2019 - Prevent Visual Basic from taking focus

    When I used to work on a worksheet in Excel 2010 and had the Visual Basic window open behind it but with parts of that window still visible, if I passed my mouse over the visible part of the Visual...
  22. Re: DllRegisterServer failed with error code 0x80004005

    Same error.
  23. Re: DllRegisterServer failed with error code 0x80004005

    Thanks for trying but I get the same error so I guess it's rewrite time.
  24. Re: DllRegisterServer failed with error code 0x80004005

    Si, I'm sorry to bother you again but when I open the Windows 10 Start menu I see this.
    183046
    Where do I find the Cmd prompt?
  25. Re: DllRegisterServer failed with error code 0x80004005

    Thank you for the useful information that I'll save for future needs, but both methods failed with the same error. The dll was written in 32 bit so I suspect I have to rewrite it in 64 bit.
  26. Re: DllRegisterServer failed with error code 0x80004005

    How do I do that?
  27. DllRegisterServer failed with error code 0x80004005

    I'm fairly new to Windows 10 and I'm trying to register a dll for the first time. When I go to the Cmd prompt and enter regsvr32 C:\My.dll I get the error shown in the Title of this question. I am an...
  28. Replies
    7
    Views
    806

    Re: [RESOLVED] Regex help please

    Thank you all for your help.
  29. Replies
    7
    Views
    806

    Re: Regex help please

    Are you on a Windows or Linux filesystem?==> macOS
    Or are the paths URLs?==> No they are file paths
    Are you trying to match any folders that are exactly "thumbnail" or "derivative"==> I want to...
  30. Replies
    7
    Views
    806

    [RESOLVED] Regex help please

    I have a slideshow application that uses regex to exclude certain pictures based on the picture's file path. It excludes thumbnails with .*/thumb*

    How can I modify that to exclude both thumbnail...
  31. Re: [RESOLVED] Autofilter Criteria Array Parameters

    Thank you all for your suggestions and jdc2000 for the link.
  32. Re: Autofilter Criteria Array Parameters

    I figured out the second part of my question.

    Array(2, strDate)

    but strDate need to be mm/dd/yyyy
  33. [RESOLVED] Autofilter Criteria Array Parameters

    In this autofilter statement

    .Range("$A$1:$D$233").AutoFilter Field:=1, Operator:=xlFilterValues, Criteria2:=Array(2, "9/1/2021")

    what does the bolded 2 represent?

    And how can I change the...
  34. Re: [RESOLVED] Bizarre Windows 10 / Excel 2019 behavior

    Thank you, that worked.
  35. [RESOLVED] Bizarre Windows 10 / Excel 2019 behavior

    I've used the attached workbook in Windows XP / Excel 2010 for 10 years without problems but when I switched to Windows 10 / Excel 2019 I get different results in column E. Column E should look like...
  36. Replies
    0
    Views
    353

    [RESOLVED] Excel date format mystery

    Nevermind.
  37. Re: Excel 2019 Recent Files - File extensions

    I have Windows 10 so it's File Explorer but I found the proper setting. Thanks.
  38. [RESOLVED] Excel 2019 Recent Files - File extensions

    In the list of workbooks I've recently edited in Excel 2019 it only shows the file name. Can I get it to also show the file extension?
  39. Replies
    5
    Views
    605

    Re: Office 365 Pros and Cons

    Thanks. My work is mainly with macros, so alternatives if I want to work on my mac?
  40. Replies
    5
    Views
    605

    Office 365 Pros and Cons

    I currently use Excel 2010 in a Windows XP (yes XP) virtual machine on my mac, but I'm looking for something more modern. Of the Office apps all I need is Excel so is Microsoft 365 Business Basic...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width