Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 6.60 seconds.

  1. Replies
    5
    Views
    135

    Re: Office 365 Pros and Cons

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

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

    Thanks!
  4. [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
  5. 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.
  6. 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...
  7. 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...
  8. 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.
    ...
  9. 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...
  10. Replies
    1
    Views
    173

    Re: [RESOLVED] Deleting non-visible rows

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

    Thanks all.
  12. Replies
    1
    Views
    173

    [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.
    ...
  13. Re: This old dog needs to learn new tricks

    Thanks. That's one of the things I was thinking about.
  14. [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...
  15. MsOf10 Re: Conditional formtting of today's date

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

    That doesn't seem to be available in Excel 2010.
  17. 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...
  18. Replies
    2
    Views
    313

    MsOf10 Re: Combobox Rowsource

    This works.

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

    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...
  20. MsOf10 Re: [RESOLVED] Invalid Property Value Mystery

    Thank you both.
  21. 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?
  22. 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...
  23. 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!
  24. 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...
  25. Replies
    2
    Views
    366

    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?
  26. 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...
  27. Replies
    5
    Views
    703

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

    Repairing the workbook corrected the problem.
  28. Replies
    5
    Views
    703

    MsOf10 Re: Can't delete blank columns

    Thanks, but see my steps 2 and 3.
  29. Replies
    5
    Views
    703

    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...
  30. Replies
    9
    Views
    728

    Re: [RESOLVED] Tricky requirement

    Thanks Zvoni but that's not necessary for my purposes.
  31. Replies
    9
    Views
    728

    Re: Tricky requirement

    Thanks peterst your VB6 code works in VBA.
  32. Replies
    9
    Views
    728

    Re: Tricky requirement

    Thanks. You missed the requirement that 1 and 7 be found twice and not just that the string contains both. I can modify your second example to do that but I was hoping for a solution that included...
  33. Replies
    9
    Views
    728

    [RESOLVED] Tricky requirement

    In my worksheet in column 'C' I have sets of 11 numbers line these

    8011
    2485
    4017
    2477
    4461
    8057
    4883
    0399
  34. Replies
    8
    Views
    680

    MsOf10 Re: Circular Reference

    Sorry for not explaining about the demo. Yes it works, but a different workbook with the same data didn't. I say "didn't" because I was able to fix the problem by going to Options->Formulas, checking...
  35. Replies
    8
    Views
    680

    MsOf10 Re: Circular Reference

    I've forgotten how xlsm files are uploaded here, but I've attached a zip file of a demo workbook.
  36. Replies
    8
    Views
    680

    MsOf10 Circular Reference

    Every 13 rows in column 'J' of my workbook I have formulas like =COUNTIF($J:$J,$J30) in row 30, =COUNTIF($J:$J,$J43) in row 43, =COUNTIF($J:$J,$J56) in row 56, etc which, as I'm sure you can figure...
  37. Replies
    3,113
    Views
    181,643

    Re: What song are you listening to right now?

    A few months ago I was listening to music in my Tesla Model S and Slacker played Blue Morning, Blue Day and it instantly became my favorite. I had heard of Foreigner before but I never realized how...
  38. Replies
    3,113
    Views
    181,643

    Re: What song are you listening to right now?

    https://www.youtube.com/watch?v=E-vPFNihnGQ

    Foreigner - Blue Morning, Blue Day
  39. Re: Resize workbook window in Excel 2019

    "Good" to know. Thanks.
  40. [RESOLVED] Resize workbook window in Excel 2019

    I just started using Excel 2019 and I have a small problem. In my old Excel 2010 when I open a workbook I see something like this where I can use controls in the upper right-hand corner of the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width