1. M

    Placing an Autofiltered range inside an array works only once

    I'm currently having a problem where an auto-filtered range is only placed inside an array on the first loop but subsequent attempts to do the same despite the range filtering correctly don't work. Set OpenWBS = Workbooks(Workbooks.Count).Worksheets(1).UsedRange...
  2. F

    VBA - Show All Data

    Hi all, I am using the below code to show all data every time a specific workbook is opened, however if I protect the sheet and share it then it does not work. When I've protected it I have ticked the box to allow the use of Auto-Filter but the code does not work. Private Sub Workbook_Open()...
  3. M

    VBA code to re-protect sheets of the workbook upon close and save that will also allow auto-filters to work

    I am new to MrExcel and new to VBA and hope you will help me. I used the following code to protect my workbook sheets before close and upon save and it works great but I can't figure out how to write it to allow filters to still work on all tabs of the workbook when protected. There are...
  4. P

    Showing unique entries in the Excel Name Manager

    I have a workbook with hundreds of names. As a result, the Name Manager is hard to navigate--see the image below. Additionally, nearly all my names are defined on a workbook level and refer to ranges, not tables. Consequently, the Name Manager's conventional filter options are useless for...
  5. N

    Autofilter 2 Criteria Issue

    I am auto-filtering on a sheet right now that will filter out anything not highlighted: ActiveSheet.Range("A:D").AutoFilter Field:=2, Operator:= _ xlFilterNoFill I want to now tack onto this code to make it auto-filter for anything not highlighted or anything highlighted...
  6. L

    Auto-filter based on cell value won't work!

    Hi! I have a VBA issue that is taking up way too much time guessing at. So, I hope that someone may be able to help! I have a product listing table ranging from A6 (heading) to BB2609 (including subtotal). I am trying to auto-filter column O to display what is found in cell O5. Cell O5 is made...
  7. J

    Two issue re auto-filter on protected sheets

    I have a big spreadsheet with macros that crunch some numbers and put out results in a new workbook: the workbook is protected, and so are all sheets, but with sorting and filtering allowed. The headers have auto-filter buttons. Issue #1: the auto-filter allows the user to filter, but upon...
  8. D

    How to hyperlink and auto-filter

    Hi, I am trying to set up a document portal for a rigging spreadsheet onboard a large vessel. I need to create hyperlink buttons that will open a new page titled - Equipment List and depending on which button you push from the front page (e.g Wire Rope Grommet, or System Sling) only the named...
  9. S

    SUBTOTAL in auto-filterered table

    Hi, I've got a table with a lot of raw data which looks something like: == TypeID, Amount -- 1, 200 1, 300 1, 100 2, 400 2, 500 8, 300 == and I want another table in another sheet in the same workbook with data like this: == TypeID, Amount -- 1, 600 2, 900 3, 0 4, 0 5, 0 6, 0 7, 0 8, 300 9...
  10. J

    Filtering on specific values contained in column

    Column A Row1 Orange-Apple-Pear Row2 Orange-Grapes-Melon Row3 Berry-Apple-Melon Row4 Banana-Grapes-Melon Row5 Orange-Grapes-Banana <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> Given the information above: <o:p> </o:p> I want to find a...

Some videos you may like

This Week's Hot Topics