+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 27 of 27

Categorize items by status of completed, open

  1. #16
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    No other macros running. just this one workbook is opened. I've opened and closed it. faced the error again. Sry man.

  2. #17
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,509

    Re: Categorize items by status of completed, open

    Ok.


    Lets get back to basics.

    Try this Macro and tell me if it works. The sort functionality is disabled.

    Ahh....... Maybe the problem is in sorting a hidden range.


    Please Login or Register  to view this content.




    Maybe this version


    Please Login or Register  to view this content.
    Last edited by mehmetcik; 01-15-2019 at 11:35 AM.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #18
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Ok i pasted the first code and it worked for collapsing and expanding the rows. No errors encountered. The sorting did not happen.
    I removed the first code and pasted the second code and the same error occurred when i clicked on the collectible rows. I have attached the file with the first code pasted on it.
    Attached Files Attached Files

  4. #19
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,509

    Re: Categorize items by status of completed, open

    Paste this code and then double click on 2011


    Please Login or Register  to view this content.
    Last edited by mehmetcik; 01-15-2019 at 09:18 PM.

  5. #20
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Hi Mehmetcik

    Which code you are referring to? The first one or the second one in post 17?

  6. #21
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Hi Mehmetcik

    I have pasted the code in post#19. When I collasped the group of 2011 there was no error but when i expanded the error happened on this line. No sorting was done as well.

    Please Login or Register  to view this content.

  7. #22
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,509

    Re: Categorize items by status of completed, open

    Is your sheet name still Sheet1?

    I do not understand why the sort is not working.

  8. #23
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Hi Mehmetcik. Yes it is still called sheet1. No change on that. Is there any other way we can amend the vba to achieve this intended result with the expandable rows?

  9. #24
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,509

    Re: Categorize items by status of completed, open

    Can you record yourself sorting some data on the sheet?, using the macro recorder.
    Then run thev macro.

    If it works then post it for me to look at.

  10. #25
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Hi Mehmetcik,

    This is the code. i sorted the data at the 2011 row. Thank you again for looking at this.

    If there is no other alternative then i guess i can instead create tabs for each year then... Will you be able to show me which code should i amend then if i am not using the expandable/collapsible rows and just auto sort to push completed below and opened to the top.

    Please Login or Register  to view this content.
    Last edited by michael35; 01-17-2019 at 08:30 AM.

  11. #26
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    6,509

    Re: Categorize items by status of completed, open

    Ok

    Paste this code. Then click on 2011

    Please Login or Register  to view this content.

  12. #27
    Forum Contributor
    Join Date
    05-16-2018
    Location
    SG
    MS-Off Ver
    2013
    Posts
    174

    Re: Categorize items by status of completed, open

    Hi Mehmetcik

    Apologies to be away for a while. this worked like u mentioned when rows 8 to 49 are visible. Can i check how do i make the same sort function work for rows thereafter row 49.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1