Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 4.05 seconds.

  1. Replies
    7
    Views
    337

    Re: [RESOLVED] Regex help please

    Thank you all for your help.
  2. Replies
    7
    Views
    337

    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...
  3. Replies
    7
    Views
    337

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

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

    Thank you, that worked.
  8. [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...
  9. Replies
    0
    Views
    192

    [RESOLVED] Excel date format mystery

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

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

    Re: Office 365 Pros and Cons

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

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

    Thanks!
  15. [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
  16. 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.
  17. 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...
  18. 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...
  19. 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.
    ...
  20. 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...
  21. Replies
    1
    Views
    350

    Re: [RESOLVED] Deleting non-visible rows

    Resolved it in a different way.
  22. Re: [RESOLVED] This old dog needs to learn new tricks

    Thanks all.
  23. Replies
    1
    Views
    350

    [RESOLVED] Deleting non-visible rows

    Given a worksheet without headers that has been filtered, and given a range that refers to the column that has the filter, i know that the following will delete all the visible rows.
    ...
  24. Re: This old dog needs to learn new tricks

    Thanks. That's one of the things I was thinking about.
  25. [RESOLVED] This old dog needs to learn new tricks

    I currently do a lot of Excel 2010 development in Windows XP as a virtual machine hosted by Parallels Desktop for Mac. I'd like to upgrade to something more modern but I don't know what the best...
  26. MsOf10 Re: Conditional formtting of today's date

    Thanks.
  27. MsOf10 Re: Conditional formtting of today's date

    That doesn't seem to be available in Excel 2010.
  28. MsOf10 [RESOLVED] Conditional formtting of today's date

    I have a row of dates in row 1 where visually today's date is shown as 15-08-2021. The dates are created by adding one to the previous cell's date. Can this be improved on so that it works and...
  29. Replies
    2
    Views
    498

    MsOf10 Re: Combobox Rowsource

    This works.

    Application.EnableEvents = False
    With MyCombobox
    .RowSource = ""
    .Clear
    .ListIndex = -1
    .RowSource = "MyNamedRange"
    End With
    Application.EnableEvents = True
  30. Replies
    2
    Views
    498

    MsOf10 [RESOLVED] Combobox Rowsource

    I have a combobox on a userform that is populated via a RowSource which is a dynamic Named Range. If I delete one of the entries in the Named Range the Named Range address changes as it should, but...
  31. MsOf10 Re: [RESOLVED] Invalid Property Value Mystery

    Thank you both.
  32. MsOf10 Re: Invalid Property Value Mystery

    I want the user to be able to add a new Project ID so how do I get around that?
  33. MsOf10 [RESOLVED] Invalid Property Value Mystery

    In the attached relatively simple workbook, click the "Maintenance" button on the "Projects" sheet. When the userform comes up, type 1 (or any other value that doesn't exist in the list) in the...
  34. MsOf10 Re: Absolutely bizarre workbook behavior

    I looked into this problem several times and it never occurred to me to check to see if those functions were being used as UDFs. Thank you!
  35. MsOf10 [RESOLVED] Absolutely bizarre workbook behavior

    I deal with a workbook and the workbook I've linked to is, believe it or not, a cut down version of that workbook, and as is none of the buttons on sheet1 work. The file is large because of the...
  36. Replies
    2
    Views
    527

    MsOf10 VBA - Transpose?

    If I have "123456789" in A1, is there something more elegant than a loop that would result in 1 in B1, 2 in B2, 3 in B3 etc?
  37. MsOf10 Function acts as if it's volatile but it isn't

    There's a Public function in a workbook of mine (that I can't post here) that gets executed repeatedly every time the workbook is calculated even though there's no Application.Volatile or for that...
  38. Replies
    5
    Views
    761

    MsOf10 Re: [RESOLVED] Can't delete blank columns

    Repairing the workbook corrected the problem.
  39. Replies
    5
    Views
    761

    MsOf10 Re: Can't delete blank columns

    Thanks, but see my steps 2 and 3.
  40. Replies
    5
    Views
    761

    MsOf10 [RESOLVED] Can't delete blank columns

    I have a worksheet with data in columns 'A' to 'BD' and rows 1 to 6776, however when I press ctrl+end I'm taken to ASD6776. In an attempt to get rid of all columns to the right of BD I

    Selected...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width