Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    OK, try tyhis:
    Note: if you're using Windows 8.1/Excel 2013 there's a bug you should know related to clipboard object. Read this article:...
  2. Replies
    7
    Views
    177

    Re: Modified Rank function?

    Try using "not exact match" in the Match Fuction (i.e 1) & remove the + 1


    Rnk = Application.WorksheetFunction.Match(x, .ToArray, 1) '''+ 1
  3. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    You're welcome, glad to help, & thanks for the feedback.:)
  4. Re: VBA to apply advance filter to find blank cells

    You're welcome.:)
  5. Re: VBA to apply advance filter to find blank cells

    In that case try ="" in the cell or in vba:

    NR.Range("B3").Value = "="""""
  6. Re: VBA to apply advance filter to find blank cells

    Have you tried using equal sign "=" (without quotes in the cell but off course with quotes in vba)


    NR.Range("B3").Value = "="
  7. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    So, does it work now?
  8. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    As I said in post 2:
    Note: you need to add the reference “Microsoft Forms 2.0 Object Library” (to work with clipboard)

    And this is how:
    1. Open your VBA editor.
    2. Click Tools > References.
    3....
  9. Replies
    5
    Views
    124

    Re: Filter Macro where cell contains

    Ok, glad it works.:)
  10. 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") &...
  11. Replies
    5
    Views
    124

    Re: Filter Macro where cell contains

    You're welcome.
    This article might be useful for you:
    https://www.contextures.com/xladvfilter01.html
  12. 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...
  13. 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...
  14. Replies
    5
    Views
    124

    Re: Filter Macro where cell contains

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

    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))
  16. 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.:)
  17. 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...
  18. Replies
    12
    Views
    162

    Re: VBA - copy cell if it is not empty

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

    Re: VBA - copy cell if it is not empty

    Try:

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

    Re: Drop Down List not working

    I have never heard of such a thing for data validation.
  21. Replies
    3
    Views
    72

    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
  22. Replies
    12
    Views
    162

    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
  23. 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...
  24. 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
  25. 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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4