Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 5.41 seconds.

  1. Replies
    4
    Views
    188

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

    Repairing the workbook corrected the problem.
  2. Replies
    4
    Views
    188

    MsOf10 Re: Can't delete blank columns

    Thanks, but see my steps 2 and 3.
  3. Replies
    4
    Views
    188

    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...
  4. Replies
    9
    Views
    342

    Re: [RESOLVED] Tricky requirement

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

    Re: Tricky requirement

    Thanks peterst your VB6 code works in VBA.
  6. Replies
    9
    Views
    342

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

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

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

    MsOf10 Re: Circular Reference

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

    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...
  11. Replies
    3,063
    Views
    114,224

    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...
  12. Replies
    3,063
    Views
    114,224

    Re: What song are you listening to right now?

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

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

    "Good" to know. Thanks.
  14. [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...
  15. Replies
    3
    Views
    457

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

    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.
  17. Replies
    5
    Views
    720

    Re: [RESOLVED] Difficut assignment

    I figured it out again.
  18. Replies
    5
    Views
    720

    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...
  19. Replies
    5
    Views
    720

    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.
  20. Replies
    5
    Views
    720

    [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...
  21. Thread: VBA CountIf

    by MartinLiss
    Replies
    2
    Views
    435

    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...
  22. Replies
    4
    Views
    620

    Re: Excel VBA - Transpose???

    Thanks westconn, that works.
  23. Replies
    4
    Views
    620

    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
  24. Replies
    4
    Views
    620

    [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?
  25. Re: Excel: Get Holidays from opm.oov using html

    Thanks. I'm going to use the formula approach you pointed out.
  26. 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.
  27. [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...
  28. Replies
    2
    Views
    506

    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
  29. Replies
    2
    Views
    506

    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...
  30. Replies
    4
    Views
    425

    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.
  31. Replies
    4
    Views
    425

    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?
  32. Replies
    1
    Views
    457

    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...
  33. Replies
    1
    Views
    457

    [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...
  34. 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...
  35. Replies
    0
    Views
    397

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

    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?
  37. Findfiltered data in another filtered column

    Ignore - sorry.
  38. MsOf10 [RESOLVED] Why does filtering work only once?

    In my code I'm filtering on column "X". In the code below column 'X' is represented by COL_CONCAT. If I open the workbook and run the code it works as expected but if I try it again it doesn't and I...
  39. Replies
    13
    Views
    1,456

    Re: [RESOLVED] $%%$$%# Personal.xlsb

    I believe I found the solution and it's kind of embarrassing but I think I owe it to the people who tried to help me and explain what the problem was.

    As I mentioned above I've worked with Excel...
  40. Re: [RESOLVED] "Reset" a With/End With structure?

    Thanks but I don't think I can do either of those things because of my For lngRow/Next loop. As I said I have a workaround that I don't want to change, but I'll actually test your suggestions when I...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width