Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    210

    Re: Finding maximum day number in column

    It works!
    Now my code will work for all days, even 1st day of another month :)

    Thank you!
  2. Replies
    5
    Views
    210

    Re: Finding maximum day number in column

    Sorry, doesn't work.

    For your code it gives "Sub or Function not defined".

    I tried adding WorksheetFunction. before Max, but then it gives error "Object doesn't support this property or method".
  3. Replies
    5
    Views
    210

    Finding maximum day number in column

    I have a column with dates. Usually it consists of dates only within one month, but very rarely it has also 1st day of the next month.
    I need to find maximum (latest) day number to use it in many...
  4. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    Thank you. I already got both fixes by myself (error handling and adding +1 to column number).
  5. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    OK, I figured that it just doesn't have error handling in case no rows to delete are found.
    It also deletes wrong column because it doesn't give helper column a header, yet looks for number of...
  6. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I'm getting "Error 1004: No cells found" on line:

    rd.SpecialCells(xlCellTypeConstants, xlNumbers).EntireRow.Delete
    Is whole VBA code updated to use last column of data?
  7. Replies
    2
    Views
    153

    Re: Use of worksheet function

    Try adding it in the last part (Range):

    Application.WorksheetFunction.Min(Workbooks(1).WorkSheets(1).Range("B1:B5"))

    RoryA was faster, I can't delete my post now...
  8. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    It took my Excel 21 minutes to calculate formula accross whole database on all rows (but I did run it on my largest database of 100k+ rows to test it). So unfortunately it's not applicable, yet it...
  9. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    Yes, in example data, all "Banana" need to be marked for deletion or deleted.

    EDIT: I tested it and got "1" in Delete column next to 1st occurence of "Banana", but not next to the other. It's...
  10. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I'll try to re-state and re-phrase what it's all about. Database has hundreds of rows. One of columns contains date (one of two, never any other than X or Y) and other column contains a name of...
  11. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I used the same table that I posted in my first post as example data with the same product names and dates. Therefore, I didn't expect anyone to use different set.

    "I need to find which products...
  12. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    These are promised screenshots of my table. You may notice that there is different name of formula. It's Polish equivalent of Countifs and works the same way. We also use ; instead of , in formulas...
  13. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    Yeah, I'm doing it the right way, getting correct rows, columns, etc. I use the same example table that I posted here. I don't know how we can get different results. I'll make a screenshot some time...
  14. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I can't upload images anywhere from my workplace (blocked), but I'll make a screenshot of finished table (with example data) from home.
    Should I move the formula down or use the exact same with same...
  15. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I can't edit my post anymore, so I'll add my temporary solution:
    1. I add pivot table with “Add this data to the Data Model” (can't do it in VBA unfortunately).
    2. In that pivot table I look for...
  16. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    Sorry for late feedback, but I had doctor's leave, so couldn't test it earlier.

    It seems that both previous and this formula give me different results and neither of them are similar to your...
  17. Replies
    11
    Views
    398

    Re: Need help to simplify VB code

    You already got this fragment:

    For sh = 1 To Sheets.Count
    Sheets(sh).Visible = -1
    Next sh
    It works on every sheet in a file. Replace Sheets.("name") in code with sh to make:


    For sh = 1 To...
  18. Replies
    26
    Views
    1,124

    Re: How to find non-duplicated dates (VBA)

    I don't know if your example has a misspell on row 3 or if it's not working properly (I don't have my real data to test it now).
    I can see that row 3, that is first occurence of "Banana" has 0 in...
  19. Replies
    11
    Views
    398

    Re: Need help to simplify VB code

    Do you have any Sheets that need that ColorA3 shape not deleted? If you're deleting them from every sheet that contain them (or all except one), then code can be much shorter by looping the code...
  20. Replies
    26
    Views
    1,124

    How to find non-duplicated dates (VBA)

    Hello!

    I have a product report that has some columns - one of them is date: one of two specified (let's say that it's always either 1st January or 9th January). Among all products there are few...
  21. Replies
    3
    Views
    251

    Re: INDIRECT function from another sheet

    That works! Thank you!
    I didn't use INDIRECT function too much, so I didn't know I can add Sheet name so far in arguments list.

    Still, how does this part work?
    =INDEX(Values!1:1048576
    It adds...
  22. Replies
    3
    Views
    251

    INDIRECT function from another sheet

    Hello!

    I almost managed to make a formula I needed, but it shows values from current sheet instead of sheet I'm interested in....
  23. Data table for chart doesn't keep formatting (Excel 2016)

    Hello!

    I recently upgraded my MS Office from 2010 to 2016 and found out that some of my charts are now showing wrong values in their data tables.

    I googled this problem and found this thread...
  24. Replies
    2
    Views
    387

    Re: Result of DAY formula as variable

    Wow, since I was already using DAY in VBA, I'm ashamed for not thinking about that. Never thought about mixing native function with Worksheetfunction result.
    Simple and smart.

    Thank you! Very...
  25. Replies
    2
    Views
    387

    Result of DAY formula as variable

    Hello!

    I got a formula in my cell assigned via VBA:

    ActiveCell.FormulaR1C1 = "=DAY(MAX(values!C8))"
    It finds the highest number of day among all values in the column.

    I want it to be my...
Results 1 to 25 of 83
Page 1 of 4 1 2 3 4