Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    9
    Views
    103

    Re: Extracting Data from a Larger Body of Data

    You're welcome, glad to help, & thanks for the feedback.:)
  2. Replies
    9
    Views
    103

    Re: Extracting Data from a Larger Body of Data

    Ok, try this:
    Run the code, it will put the result in sheet2, you may change that to suit.


    Sub a1112986a()...
  3. Re: Need a [VBA] code which show a Pop Box in Excel if condition is meet.

    You're welcome, glad to help, & thanks for the feedback.:)
  4. Replies
    9
    Views
    103

    Re: Extracting Data from a Larger Body of Data

    Do you want to extract the 55 product codes all at once to a sheet or each product code to separate sheet?
  5. Re: Need a [VBA] code which show a Pop Box in Excel if condition is meet.

    Can you explain in more detail "it is not Working"?
    Private Sub Worksheet_Activate() is triggered when you open another sheet then go back to the sheet.
  6. Re: Need a [VBA] code which show a Pop Box in Excel if condition is meet.

    Try this:
    Put the code in the code module of the sheet in question:


    Private Sub Worksheet_Activate()
    Dim i As Long
    Dim va

    va = Range("D1", Cells(Rows.Count, "D").End(xlUp))
  7. Replies
    33
    Views
    693

    Re: Date data validation formula

    Ok, try this:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Cells.CountLarge <> 1 Then Exit Sub

    If Not Intersect(Target, Range("A1:A20")) Is Nothing Then

    ...
  8. Replies
    33
    Views
    693

    Re: Date data validation formula

    Ok, so the conflict only happens if for the same second criteria (x,y or z) user pick whole venue & any colored room within 7 days?
    If user doesn't pick whole venue then there is no situation that...
  9. Replies
    33
    Views
    693

    Re: Date data validation formula

    Sorry, I kind of forget what you really mean by occur within 7 days, does it include the same day?
    So if green room X with green room Y occur in the same day it's not a conflict?
  10. Replies
    33
    Views
    693

    Re: Date data validation formula

    What about green room X with green room Y? is it a conflict?
  11. Replies
    33
    Views
    693

    Re: Date data validation formula

    Is the second criteria required or it can be empty?
  12. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    Ok, just replace this line:


    Write #1, tx

    with this:


    Print #1, tx
  13. Re: Using VBA to find the address of maximum in a range containing formulae

    Because of Dim FinSeq As Range, it should be:
    Dim FinSeq As Long
  14. Re: remove quotation from excel while pasting the data

    I forgot something:
    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. Check...
  15. Re: remove quotation from excel while pasting the data

    OK, try this:


    Sub a1112871a()
    'https://www.mrexcel.com/forum/excel-questions/1112871-remove-quotation-excel-while-pasting-data.html
    Dim obj As New DataObject
    Dim tx As String

    ...
  16. Re: remove quotation from excel while pasting the data

    In my experience, when I copy paste from excel to a text file, it will add quotation marks if the cell has multiple lines. Is that what happens with your data?

    I think you will need vba code to...
  17. 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:...
  18. Replies
    7
    Views
    227

    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
  19. 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.:)
  20. Re: VBA to apply advance filter to find blank cells

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

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

    NR.Range("B3").Value = "="""""
  22. 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 = "="
  23. Re: CopyPaste Macro to skip blank cells and zero values OR Delete Blank Cells and zero values

    So, does it work now?
  24. 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....
  25. Replies
    5
    Views
    131

    Re: Filter Macro where cell contains

    Ok, glad it works.:)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4