Search:

Type: Posts; User: MartinLiss

Page 1 of 13 1 2 3 4

Search: Search took 4.09 seconds; generated 42 minute(s) ago.

  1. Re: How to compare the similarity of two words in VB?

    It's VBA code with two versions. Put either one in a code module and see what happens. You can also search VBForums for 'soundx' and probably find an answer. BTW, what exactly happened when you tried...
  2. Re: How to compare the similarity of two words in VB?

    Please see this explanation.

    https://www.source-code.biz/snippets/vbasic/4.htm
  3. Replies
    8
    Views
    19,999

    Re: Scroll bar in picturebox

    You guys may not have noticed, but this thread is 14 years old.
  4. Re: Ecxcel vexing autofilter problem

    I've found a completely different way to do this.
  5. [RESOLVED] Ecxcel vexing autofilter problem

    I have this macro which is supposed to copy all yellow-colored cell to Range("A1") in the destination worksheet and I'm using autofilter since there are > 100,000 cells that MIGHT be yellow. I've...
  6. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    Thanks, but as i mentioned above "...the number of values in the source is variable and there could be a hundred or more values in it, so I assume I would need to use VBA to populate the formula...
  7. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    BTW, I know how to use Join on the source data to produce a string like 1-2-3-4-5-6-7 where the dashes represent spaces, but I could not figure out how to paste that string into the output row...
  8. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    Yes.
  9. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    The forum is not even allowing me to add a picture so this is the best I can do.
    SOURCE
    Column A: a date
    Column B: 1
    Column C: 2
    Column D: 3
    Column E: 4
    Column F: 5
    Column G: 6
    Column H: 7
  10. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    Here is a link to a demo file. When you click the button two new worksheets will be created from the Database worksheet's data.

    https://www.mediafire.com/file/4g5ry2fokq8wqmk/Demo.xlsm/file
  11. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    Zvoni, I am looking to insert blank columns, and the formula in your reference looks promising, but despite what my question said, the number of values in the source is variable and there could be a...
  12. Replies
    18
    Views
    770

    Re: Copy/Paste with blank cells inbetween

    Thanks but I know how to use a loop, and what I was hoping for was a way to do it without one.
  13. Replies
    18
    Views
    770

    Copy/Paste with blank cells inbetween

    I have a worksheet where B3 is "1", B4 is "5", B5 is "7" etcetera to B8. I'd like to paste those values to another worksheet starting in C5 but with a blank cell in-between the output cells. In other...
  14. Re: Use VBA to create a Visual Basic 64 bit Add-in for Excel

    Thanks then but I'm looking for a VBA solution and I've changed my question's title to reflect that.
  15. Re: Creating a Visual Basic 64 bit Add-in for Excel

    fafalone, are you talking about VB6?
  16. Re: Creating a Visual Basic 64 bit Add-in for Excel

    Thanks, but to be clearer, I'm talking about the kind of add-in that can be used in the Visual Basic area of Excel. For example I wrote one for 32 bit where it made it easier for a coder to annotate...
  17. Use VBA to create a Visual Basic 64 bit Add-in for Excel

    Is it possible?
    Have you done it?
    Do I need Visual Studio?
  18. Re: Why do I get a type mismatch error?

    Thank you for your efforts. I resolved the problem which was partially due to the fact that the range should have been 2:2 and not 1:1.
  19. Re: Why do I get a type mismatch error?

    In my case I'm trying to hide and unhide columns on the active sheet and not worksheets.
  20. [RESOLVED] Why do I get a type mismatch error?

    In the active sheet I have a button that shows a userform vbmodeless which lists, by name, certain columns in the worksheet. The OK button works if the column isn't hidden but if it is I get the...
  21. Replies
    2
    Views
    1,107

    Re: Help break a WORKBOOK password

    Thanks!!
  22. Replies
    2
    Views
    1,107

    [RESOLVED] Help break a WORKBOOK password

    I use a workbook that I created at least 10 years ago. Today I tried to delete a worksheet but all the options to do that were turned off. The things I tried indicate to me that the structure of the...
  23. Re: Subtract from AVERAGE formula

    Thanks.
  24. [RESOLVED] Subtract from AVERAGE formula

    In my workbook I have a named range called MonthPoints on worksheet 'Rank' which currently refers to all of column D except for the single heading row. That named range is defined as:...
  25. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    Thank you for doing that.
  26. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    Thanks Zvoni, but the data is in Excel and I don't have access to that data on the web.
  27. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    The range rng3 is a combination of the 3 columns, so I'm not doing 3 lookups per row.
  28. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    Here is that code:


    Sub PruneTradeArea()
    Dim lngLastRow As Long
    Dim lngRow As Long
    Dim rngFW As Range
    Dim cel As Range
    Dim rng3 As Range
    Dim rngFound As Range
  29. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    Below is a link to a small(er) sample you can test with. In Module1 you'll find 3 macros:

    Test: Your code as modified by me
    PruneTradeArea: My current code
    Func_Search_Range_With_MATCH

    If...
  30. Replies
    12
    Views
    1,958

    Re: Help speed up seatrch

    Thanks but strColumnValue wasn't defined and when I changed it to strColumnXValue only 25 rows were marked for deletion, where about 60% should have been marked.
  31. Replies
    12
    Views
    1,958

    Help speed up seatrch

    I have Sheet1 with 55 thousand rows and in another worksheet I have a named range consisting of a single column containing 450 values. Since the cells in F to H may contain multiple words in a cell,...
  32. Replies
    1
    Views
    709

    [RESOLVED] Can't Copy/Paste

    There is a worksheet in my workbook that won't allow me to copy/paste. Other worksheets do. What happens is that after I copy a call and then I right-click, the Paste options are grayed out. When I...
  33. Replies
    0
    Views
    660

    [RESOLVED] Sorting a table

    I would like to sort each column of table that has a variable number of columns, where when sorting for example column 2, it doesn't affect the sort order of the other columns. In other words I want...
  34. Replies
    2
    Views
    1,279

    .FindNext error

    I have this code where rngFound is a range. When I run it Excel highlights .FindNext and tells me "Method or data member not found". I've used .FindNext before without any problems. Why now?


    ...
  35. Replies
    4
    Views
    881

    Re: Exporting an array formula

    I changed the formulas to non-array formulas and the problem went away.
  36. Replies
    4
    Views
    881

    Re: Exporting an array formula

    The copying of the worksheets is being done by VBA code.
  37. Replies
    4
    Views
    881

    [RESOLVED] Exporting an array formula

    I have a worksheet that has an array formula that begins with
    =IF(_xlfn._xlws.FILTER('Support - TAM'!H:L,('Support - TAM'!L:L="Complete")

    When I copy that sheet to another workbook it shows up...
  38. Replies
    4
    Views
    870

    Re: Excel internal link

    @OB1: It's an xlsx workbook so I don't believe your suggestion can work.
    @Zvoni: Thanks. It definitely is a textbox. However when right-clicking on it I noticed 'Edit Link' which solves my problem.
  39. Replies
    4
    Views
    870

    [RESOLVED] Excel internal link

    In an xlxs workbook on Sheet1 there is a textbox that when clicked takes me to Sheet2!A1, How is a link like that created?
  40. Re: Fastest way to clear cells based on cel length

    Thanks.
Results 1 to 40 of 498
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width