Search:

Type: Posts; User: Akuini; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    5
    Views
    115

    Re: Filter Macro where cell contains

    Ok, glad it works.:)
  2. Re: Code adjustment for numbering items needed-vba

    In that case you can use WorksheetFunction.Max.
    I don't know how you insert the value to the cell in col A:B, basically you can use it like this:
    Let's say the working range is Range("A1:B10") &...
  3. Replies
    5
    Views
    115

    Re: Filter Macro where cell contains

    You're welcome.
    This article might be useful for you:
    https://www.contextures.com/xladvfilter01.html
  4. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    Glad you figured it out.:)



    My code use clipboard object & modify the content as your requirements, so you can send it to a text file directly (without copy-paste it to another sheet first). So...
  5. Re: Code adjustment for numbering items needed-vba

    Just to be clear you also don't want duplicate number in each column, right? So you can't insert 2 in col A if 2 already exist in col A.

    Let's say only 1 & 2 exist in col A:B, then you try to...
  6. Replies
    5
    Views
    115

    Re: Filter Macro where cell contains

    Try putting the keyword between 2 asterisk, like this:
    *National*
  7. Replies
    17
    Views
    299

    Re: Place sub category's letters in all items

    Maybe this is what you want:


    Sub a1112401a()

    Dim i As Long, j As Long, k As Long
    Dim va
    Dim pref As String

    va = Range("G13", Cells(Rows.count, "G").End(xlUp))
  8. Re: Detect if worksheet exist, and if it does ignore the rest of the script

    Dim ary is the same with Dim ary as Variant

    You're welcome, glad to help, & thanks for the feedback.:)
  9. Re: Detect if worksheet exist, and if it does ignore the rest of the script

    So the end part of the sheet's name is something like -1, -55, -566 etc?
    Try this:


    Dim ws As Worksheet
    Dim ary
    For Each ws In Worksheets
    ary = Split(ws.Name, "-")
    If...
  10. Replies
    12
    Views
    150

    Re: VBA - copy cell if it is not empty

    You're welcome, glad to help, & thanks for the feedback.:)
  11. Replies
    12
    Views
    150

    Re: VBA - copy cell if it is not empty

    Try:

    With Range("F31:F34")
    .Copy
    .Offset(, -1).PasteSpecial paste:=xlPasteValues, SkipBlanks:=True
    End With
  12. Replies
    3
    Views
    69

    Re: Drop Down List not working

    I have never heard of such a thing for data validation.
  13. Replies
    3
    Views
    69

    Re: Drop Down List not working

    Are you talking about activex combobox or data validation?
    If you're talking about activex combobox then:
    Set MatchEntry property to fmMatchEntryFirstLetter
  14. Replies
    12
    Views
    150

    Re: VBA - copy cell if it is not empty

    Another way:


    With Range("F1", Cells(Rows.count, "F").End(xlUp))
    .Copy
    .Offset(, -1).PasteSpecial paste:=xlPasteValues, SkipBlanks:=True
    End With
  15. Re: userform combobox - autocomplete with drop down box

    I think it is a different problem, so you need to start a new thread. And I suggest you provide a sample workbook and upload it to a free site such as dropbox.com & then put the link in the new...
  16. Re: userform combobox - autocomplete with drop down box

    This is an example of a searchable combobox in userform:

    https://www.dropbox.com/s/op00l707u8qxdnj/dhee%20-%20searchable%20combobox-userform%20-%20example.xlsm?dl=0
  17. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    I assume your data is in a single column.
    You can use a clipboard object, like this:
    Note: you need to add the reference “Microsoft Forms 2.0 Object Library” (to work with clipboard)


    Sub...
  18. Replies
    2
    Views
    130

    Re: Get array from filtered results

    You can use dictionary object as an array criteria.
    Here's an example:


    Sub a1112343a()
    'https://www.mrexcel.com/forum/excel-questions/1112343-get-array-filtered-results.html
    Dim c As Range...
  19. Replies
    2
    Views
    84

    Re: VBA Help - Auto Hide Row

    Could you show us the formula?
  20. Replies
    18
    Views
    416

    Re: Need Help with VBA Code to Hide/Unhide Rows

    You're welcome.
  21. Replies
    29
    Views
    700

    Re: Separate Dates With Blank, Unformatted Row

    You're welcome, glad to help, & thanks for the feedback.:)
  22. Replies
    29
    Views
    700

    Re: Separate Dates With Blank, Unformatted Row

    So the criteria are:
    1. all building numbers that begin with 32 or below are removed.
    2. all dates (in col E) prior to today's date are removed.

    Try this:


    Sub a1109941e()
    Dim i As Long, n...
  23. Re: How to -If cell is Green, copy 50 rows below it and paste to new sheet

    Sorry, the code in post 2 above won't work if the colored cell in question is empty. So to make it also work on empty cell:

    replace this:

    Set c = Range("A:A").Find(What:="*",...
  24. Re: How to -If cell is Green, copy 50 rows below it and paste to new sheet

    Try this:
    This will cut 50 rows below the colored cell in question and paste it into a new sheet.


    Sub a1111856a()...
  25. Re: Populate a listbox from a range skipping duplicates

    You're welcome, glad to help, & thanks for the feedback.:)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4