Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds; generated 56 minute(s) ago.

  1. Replies
    2
    Views
    63

    Re: Prevent user interrupting Macro ?

    You can put your macro, maybe we can improve it a bit.
  2. Re: Filter Table save as new workbook in same folder

    I'm glad to help you. Thanks for the feedback.
  3. Replies
    3
    Views
    87

    Re: IF function with cursor move

    I'm glad to help you. Thanks for the feedback.
  4. Re: VBA MACRO TO Keep duplicates BASED ON CONDITION (Remove duplicate if the duplicate count of a particular id is greater 12 times

    Hi @★ ayushdadhich11,

    Try the following. I performed a test with 9,000 records and the result is immediate.



    Sub Keep_duplicates()
    Dim sh As Worksheet, ky As Variant, lr As Long, lc As...
  5. Re: Filter Table save as new workbook in same folder

    Try this



    Sub Test()
    Dim sh As Worksheet, c As Range, ky As Variant, wb As Workbook, wPath As String, lr As Long

    Application.SheetsInNewWorkbook = 1
    Application.ScreenUpdating =...
  6. Re: Extracting numbers before and after spaces

    Glad to help you. Thanks for the feedback.
  7. Re: Delete rows if cell value is greater than a specific time

    something in the column other than a date?
    In which row start data?
  8. Re: Close all ComboBox dropdowns when I click a button.

    If you select a cell, does the dropdown close?
  9. Re: Excel formula to update values for specific columns only

    You can play a little with a pivot table and check if the result is what you need.

    http://tedata.blob.core.windows.net/uploads/md/ad569729a1c18165f521172fcf4febc1.jpg
  10. Replies
    1
    Views
    46

    Re: ThisWorkbook Question

    If the sheet occupies position 2 of your sheets then simply:



    ThisWorkbook.Sheets(2).Range("B11:X180")
  11. Re: Extracting numbers before and after spaces

    Try:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  12. Replies
    3
    Views
    87

    Re: IF function with cursor move

    Welcome to the forum!

    Put the following macro in sheet events



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    If Not Intersect(Target,...
  13. Re: VBA MACRO TO Keep duplicates BASED ON CONDITION (Remove duplicate if the duplicate count of a particular id is greater 12 times

    Welcome to the forum.

    Please coment:
    - In which row the data starts
    - In which column are the dates
    - in which column are the Id's
  14. Re: Copy several cell values into another workbook based of the criteria

    Try this.
    I assume that the header row of the source sheet begins in row 1, if it is another row, then change the value 1.



    Sub Copy_into_another_workbook()
    Dim w2 As Workbook, s1 As...
  15. Replies
    1
    Views
    92

    Re: How do I highlight duplicated data

    In your example, which row do you want to delete 14 or 25?
    And what should the macro do if it has more than 2 duplicate rows?
  16. Re: Cell address locating by text or value in a cell with address formula in a multiple columns data set

    How about:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col...
  17. Re: Filter Table save as new workbook in same folder

    The result is a single book?
    Or do you want a book for each manager?
    It is not clear to me. You could give an example of what you have on each sheet and what you expect from the result in the new...
  18. Replies
    3
    Views
    87

    Re: Relace and Delete Question!

    Youre welcome!
  19. Replies
    3
    Views
    87

    Re: Relace and Delete Question!

    If you want to delete the rows.
    - Select column
    - Autofilter
    - Fiter = 456
    - Now select all rows filtered
    - Press right mouse click on any cell of a selected row
    - In the menu select delete row.
  20. Re: Count number of months per year between two dates

    Please note:

    https://www.excelguru.ca/content.php?184
  21. Re: VBA Help - If Cell Contains Partial String Then.......

    sorry, typo error



    If InStr(1, Cell.Offset(0, 2), "P Card") > 0 Then
  22. Re: VBA Help - If Cell Contains Partial String Then.......

    try without wildcard



    If InStr(1, Cell.Offset(0, 2), "P Card) > 0 Then
  23. Replies
    2
    Views
    97

    Re: VBA - Open PDF file

    Try:



    Sub test() ActiveWorkbook.FollowHyperlink "C:\Users\i ' M\Desktop\PDF\test file 123-234.pdf"
    End Sub
  24. Re: Formatting a label caption as "$##,###.##"

    Try:



    Budget = " " & Format(ws.Cells(SelectedRow, 34).Value, "$##,###.00")
  25. Re: Inserting Character From End of String

    If you want the result in the same column, we can use Rick's formula in the following macro.
    The code assumes that the data begins in row 2.



    Sub Add_Dot()
    With Range("A2", Range("A" &...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4