Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 0.20 seconds.

  1. Re: [RESOLVED] Help me find an undefined variable

    Opening the workbook with Repair fixed the problem.
  2. [RESOLVED] Help me find an undefined variable

    I have a lengthy macro in a module that has Option Explicit. It compiles with no problems and runs without error for me in Excel 2019, however someone else running it in an unknown version of Excel...
  3. Re: Display contents of Word file in OLE container

    Windows XP on the same computer. My Windows XP is actually a virtual machine on my iMac but I've never seen that make any difference.
  4. Re: Display contents of Word file in OLE container

    When I added the OLE control to my form it asked what the Class was and I said Microsoft Word and it shows Word.Document.12 in the control's properties. However when I Debug.Print the class it says...
  5. Display contents of Word file in OLE container

    I have the following code. When it runs it only displays the name of the file in my form's OLE container. How do I display the document's content?

    Private Sub Command1_Click()
    OLE1.DisplayType =...
  6. Replies
    0
    Views
    257

    [RESOLVED] Fastest Transformation

    In the attached workbook I'd like the fastest code that will create Sheet2 as a transformation of Sheet1, retaining Sheet2's headings. Sheet2 should have the same colors as Sheet1. I have code that...
  7. Replies
    2
    Views
    457

    Re: Named Range Formula Problem

    Thanks!
  8. Replies
    2
    Views
    457

    [RESOLVED] Named Range Formula Problem

    Column J in my workbook has three headings and a variable number of rows starting in row 4. The following flexible formula works just fine (it refers properly to all the data in J starting at row 4)...
  9. Replies
    4
    Views
    372

    Re: COUNTIF woes

    Thanks, that was it. I'm using VBA to do this and apparently during early testing I accidentally wrote data way down in row 7000 that wasn't cleared.
  10. Replies
    4
    Views
    372

    [RESOLVED] COUNTIF woes

    I have a column that has values like the following and I wanted to count how many times 60 occurs. Using COUNTIF I expected the answer to be 1, but the formula =COUNTIF(A:A,60) returns 2 because 60...
  11. Replies
    2
    Views
    390

    Re: Need Excel Formula Help

    Thanks!
  12. Replies
    2
    Views
    390

    [RESOLVED] Need Excel Formula Help

    The formula in column F is =IF($E3<>"","",SUM($C3:$D3)). How can I change it so that the 0.00 values in column F are eliminated leaving F6 as is.
    184526
  13. Re: Formula - Keep destination formatting

    You are correct. Thanks.
  14. [RESOLVED] Formula - Keep destination formatting

    I have this formula in Sheet1
    ='Sheet2'!C8

    The source cell has no fill color but the destination cell has a fill color. How do I modify that formula so that the destination cell's fill color is...
  15. Replies
    4
    Views
    381

    Re: Scraping a lotto site

    Thanks.
  16. Replies
    4
    Views
    381

    Re: Scraping a lotto site

    "...found on this site..."
  17. Replies
    4
    Views
    381

    Scraping a lotto site

    Someone has asked me to get the lotto winning number results from a website. I've never done anything like that before and so after some research I have this so far. What table name do I use and how...
  18. Re: Show available workbooks in date descending order

    That's correct, I'm not.

    I'm using Excel 2019's Open dialog.
    184406
  19. Re: Show available workbooks in date descending order

    Thanks, but Windows Explorer (in my case actually File Explorer) shows newest first.
  20. Show available workbooks in date descending order

    I use Excel 2019 under Windows 10. When I want to open a file in for example my Downloads folder it shows me the files oldest first and I then have to click the "date modified" sort button. That's no...
  21. Replies
    1
    Views
    268

    MSHflexgrid determine if row is fixed

    I have a MSHflexgrid that has one fixed row and the values in that row are not always the same. I have code that allows rows to be moved to a second mshflexgrid based on the value of column 1 that...
  22. Re: Public Functions run for no apparent reason

    As I was composing this question I thought "You dummy, why don't you see what Google has to say?" and as you might expect the answer is there and it's that Public functions are run anytime a recalc...
  23. Public Functions run for no apparent reason

    I have 3 Public Functions in a workbook that run for no apparent reason. The declarations of the functions look like this:

    Public Function MyFunction(v As String) As String
    They do not have...
  24. Replies
    2
    Views
    2,141

    Re: [RESOLVED] Applescript

    I apologize for forgetting to mark this as Resolved.

    I don't believe that you can create an Applescript that will directly open your Google calendar from the dock, but you can create an app from...
  25. Replies
    2
    Views
    2,141

    [RESOLVED] Applescript

    In macOS is it possible to write an Applescript that will open my Google calendar?
  26. Re: [RESOLVED] Get row number of the row that's at the top of the window

    ActiveWindow.visiblerange.Row
  27. [RESOLVED] Get row number of the row that's at the top of the window

    Let's say I have a worksheet with 1000 records, none of which are hidden, and visually I see that row 18 is at the top of the window. How can I use VBA to return 18?
  28. Re: [RESOLVED] A question for Kaiser (Northern California) members

    I'm sorry that I didn't mention that I got what I needed from the KP digital app as Steve uggested.
  29. 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....
  30. 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!
  31. [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...
  32. [RESOLVED] A question for Kaiser (Northern California) members

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

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

    In those terms the patterns for a 3 digit number are:
    AAA
    AAB
    BAA
    ABC
  38. 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...
  39. 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...
  40. [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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width