Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 4.62 seconds.

  1. 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....
  2. 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!
  3. [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...
  4. [RESOLVED] A question for Kaiser (Northern California) members

    How do I download a copy of my Kaiser COVID vaccination cared to my iPhone?
  5. 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.
  6. Re: Possible patters of a 4 digit number

    Thanks for your help.
  7. 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.
  8. 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
  9. Re: Possible patters of a 4 digit number

    In those terms the patterns for a 3 digit number are:
    AAA
    AAB
    BAA
    ABC
  10. 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...
  11. 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...
  12. [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...
  13. 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.
  14. 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...
  15. Re: DllRegisterServer failed with error code 0x80004005

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

    Thanks for trying but I get the same error so I guess it's rewrite time.
  17. 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?
  18. 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.
  19. Re: DllRegisterServer failed with error code 0x80004005

    How do I do that?
  20. 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...
  21. Replies
    7
    Views
    750

    Re: [RESOLVED] Regex help please

    Thank you all for your help.
  22. Replies
    7
    Views
    750

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

    [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...
  24. Re: [RESOLVED] Autofilter Criteria Array Parameters

    Thank you all for your suggestions and jdc2000 for the link.
  25. 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
  26. [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...
  27. Re: [RESOLVED] Bizarre Windows 10 / Excel 2019 behavior

    Thank you, that worked.
  28. [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...
  29. Replies
    0
    Views
    317

    [RESOLVED] Excel date format mystery

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

    I have Windows 10 so it's File Explorer but I found the proper setting. Thanks.
  31. [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?
  32. Replies
    5
    Views
    545

    Re: Office 365 Pros and Cons

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

    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...
  34. Re: Userform Listbox Unnecessarily Wide

    Thanks!
  35. [RESOLVED] Userform Listbox Unnecessarily Wide

    I have a listbox on a userform that looks like this. The listbox width is set to 88 which is the smallest value that doesn't produce a horiontal scrollbar. Why does it need to be that large?
    182303
  36. MsOf10 Re: [RESOLVED] What can cause Excel to think I have over a million rows

    The problem was resolved by deleting the bottom rows in chunks and saving the file after each deletion.
  37. MsOf10 Re: What can cause Excel to think I have over a million rows

    Thanks, but I know how to find the last row.

    Concerning CZ8669. I didn't mention it in my question but in the workbook I attached I already cleared all formatting and formulas in all the rows...
  38. MsOf10 Re: What can cause Excel to think I have over a million rows

    Thanks but my problem is not finding the correct last row which I believe is row 6808, but rather that because Excel thinks the used range extends to row 1,048,576576
    1) The size of the workbook...
  39. MsOf10 Re: What can cause Excel to think I have over a million rows

    Here is the crazy worksheet. It's too big to attach directly. Disclaimer: I did not create the workbook of which this worksheet is a part.
    ...
  40. MsOf10 [RESOLVED] What can cause Excel to think I have over a million rows

    I've posted similar questions before but haven't been able to solve the problem which is that while I only have about 6800 rows in my worksheet, Excel thinks the last row is 1,048,576! I know that...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width