Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 5.59 seconds.

  1. 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!
  2. 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...
  3. Replies
    1
    Views
    216

    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?
  4. 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...
  5. Replies
    5
    Views
    539

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

    Repairing the workbook corrected the problem.
  6. Replies
    5
    Views
    539

    MsOf10 Re: Can't delete blank columns

    Thanks, but see my steps 2 and 3.
  7. Replies
    5
    Views
    539

    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...
  8. Replies
    9
    Views
    591

    Re: [RESOLVED] Tricky requirement

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

    Re: Tricky requirement

    Thanks peterst your VB6 code works in VBA.
  10. Replies
    9
    Views
    591

    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...
  11. Replies
    9
    Views
    591

    [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
  12. Replies
    8
    Views
    605

    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...
  13. Replies
    8
    Views
    605

    MsOf10 Re: Circular Reference

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

    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...
  15. Replies
    3,071
    Views
    135,478

    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...
  16. Replies
    3,071
    Views
    135,478

    Re: What song are you listening to right now?

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

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

    "Good" to know. Thanks.
  18. [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...
  19. Replies
    3
    Views
    491

    Re: What color is a table Header?

    Thanks (and I really mean that) but the first link applies only to Word, I know how to do the second but it doesn't answer my question, and the 3rd, while valuable, again doesn't answer my question.
  20. Replies
    3
    Views
    491

    What color is a table Header?

    Given a table in Excel, how do I determine what the color of the header is? What I'm trying to do is if a row in table2 = a row in table1, color table2's row the color of table1's header.
  21. Replies
    5
    Views
    767

    Re: [RESOLVED] Difficut assignment

    I figured it out again.
  22. Replies
    5
    Views
    767

    Re: Difficut assignment

    westconn1, what I thought was a solution didn't actually work properly so if your still willing to look into it I'd appreciate it.

    To answer your questions, there is no priority among staff...
  23. Replies
    5
    Views
    767

    Re: Difficut assignment

    Thanks for looking at this but as I woke uo this morning I had an insite that will allow me to complete this.
  24. Replies
    5
    Views
    767

    [RESOLVED] Difficut assignment

    The attached file is a staff scheduling tool for assigning staff to "slots" in 6 cafeterias. Each cafeteria has two shifts every day except Friday where there is no PM shift.I'm having great...
  25. Thread: VBA CountIf

    by MartinLiss
    Replies
    2
    Views
    468

    VBA CountIf

    I have a range that contains 90 non-contiguous cells and I'm trying to use Application.WorksheetFunction.CountIf to return the total number of cells with a specific value but I keep getting syntax...
  26. Replies
    4
    Views
    669

    Re: Excel VBA - Transpose???

    Thanks westconn, that works.
  27. Replies
    4
    Views
    669

    Re: Excel VBA - Transpose???

    No I don't. The actual range however is longer and I want to avoid code like this

    For lngRow = 1 to 50
    MyString= MyString & Cells(lngRow, "A")
    Next
  28. Replies
    4
    Views
    669

    [RESOLVED] Excel VBA - Transpose???

    If I have 9 in cell A1, 8 in cell A2 and 7 in cell A3, is it possible to create a string with the value "987" without looping?
  29. Re: Excel: Get Holidays from opm.oov using html

    Thanks. I'm going to use the formula approach you pointed out.
  30. Re: Excel: Get Holidays from opm.oov using html

    That's true but I'm willing to risk that. And thanks for the link. I may use it.
  31. [RESOLVED] Excel: Get Holidays from opm.oov using html

    The opm.gov website has list of US federal holidays that I would like to import into Excel. I know that I should be able to use the 'From Web' button on the Data tab, but I have a very old browser...
  32. Replies
    2
    Views
    539

    Re: MZTOOLS in Excel

    No, since it works in VB6 so shouldn't it work in Excel. Excel's Add-In Manager shows me this
    179609
    while VB6's shows me this.
    179610
  33. Replies
    2
    Views
    539

    MZTOOLS in Excel

    I have an old XP machine and on it are both VB6 and Excel 2010. I used to use MZTOOLS 3.0 in both of them but I had a problem with Excel and MZTOOLS no longer appears in the Add-In Manager. How do I...
  34. Replies
    4
    Views
    461

    Re: Windows 10 Pro License key

    Thanks but mu "latest" version is XP, and because of a problem I don't even have that any more.
  35. Replies
    4
    Views
    461

    Windows 10 Pro License key

    I just had Windows 10 installed via an ISO file. What is the best way to get a license key?
  36. Replies
    1
    Views
    493

    Re: Excel copy after probem

    The workbooks need to be visible which they weren't. After that it's simple.


    For Each ws In wbSource.Worksheets
    If Left(ws.Name, 3) = "tab" Then
    ws.Copy...
  37. Replies
    1
    Views
    493

    [RESOLVED] Excel copy after probem

    I have some code which opens a source workbook and assigns it to a wbSource object and opens a destination workbook and assigns it to a wbDest object.

    My aim is then to copy some of the sheets...
  38. Speed up and improve Google Translate code

    I have the following code which is used to translate the text in a worksheet's cells from any language to English. It is called from a For-Each-cell loop. It works most of the time but once in a...
  39. Replies
    0
    Views
    424

    Using Google Translate

    I have a worksheet that contains random words and phrases in several non-English languages, plus dates and numbers. The "Translate" sub in this code which I found on the web drives the process of...
  40. Replies
    3
    Views
    1,033

    Mac to Mac home network video

    Strange question i know, but is it possible for my wife and I to have a video chat between ourselves on our macs over our home network?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width