Search:

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

Page 1 of 6 1 2 3 4

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

  1. Replies
    4
    Views
    128

    Re: VBA - Open PDF file

    Try this



    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim fName As String, lrB As Long
    Cancel = True
    fName = "C:\Users\i ' M\Desktop\PDF\" &...
  2. Replies
    5
    Views
    98

    Re: IF function with cursor move

    Try this



    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count > 1 Then Exit Sub
    'select next row
    If Not Intersect(Target, Range("D:D")) Is Nothing Then
    If...
  3. Re: Formatting a label caption as "$##,###.##"

    That may be because in the cell you have a text, check if in the cell you have a text or a numerical value.
  4. Re: Delete rows if cell value is greater than a specific time

    Hi @Rackette, taking advantage of the Trebor code, I adapted it in my code to work and leave a more compact macro.



    Sub Delete_Rows()
    Dim lr As Long, i As Long, a, r As Range, exists As...
  5. Re: Macro for counting files by date range

    I'm glad to help you. Thanks for the feedback.
  6. Replies
    2
    Views
    63

    Re: Prevent user interrupting Macro ?

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

    I'm glad to help you. Thanks for the feedback.
  8. Replies
    5
    Views
    98

    Re: IF function with cursor move

    I'm glad to help you. Thanks for the feedback.
  9. 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...
  10. 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 =...
  11. Re: Extracting numbers before and after spaces

    Glad to help you. Thanks for the feedback.
  12. 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?
  13. Re: Close all ComboBox dropdowns when I click a button.

    If you select a cell, does the dropdown close?
  14. 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
  15. Replies
    1
    Views
    46

    Re: ThisWorkbook Question

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



    ThisWorkbook.Sheets(2).Range("B11:X180")
  16. 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...
  17. Replies
    5
    Views
    98

    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,...
  18. 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
  19. 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...
  20. 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?
  21. 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...
  22. 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...
  23. Replies
    3
    Views
    88

    Re: Relace and Delete Question!

    Youre welcome!
  24. Replies
    3
    Views
    88

    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.
  25. Re: Count number of months per year between two dates

    Please note:

    https://www.excelguru.ca/content.php?184
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4