Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting a debug 'Method range of worksheet failed' for the following
macro: Sub MyTeamFilter() Dim c As Range Dim ws As Worksheet Dim iEnd As Long UndoMyTeamFilter Set ws = Sheets("Weekly Performance") iEnd = ws.Range("B4").End(xlDown).Row For Each c In ws.Range("B4:B" & iEnd) If c = ws.Range("[TeamFilter]") Then c.EntireRow.Hidden = True Next c End Sub Teamfilter is a named range on my 'Control' worksheet. I am trying to filter the weekly performance based on the dropdown selected in 'TeamFilter'. Any help would be appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filter based on named range cell - debug help required | Excel Programming | |||
How to update a worksheet based on a defined named range using VB. | Excel Programming | |||
Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
Finding a named range based on cell value and copy/paste to same sheet? | Excel Programming | |||
How Do I Do an Exclude Filter based on a Named Range? | Excel Worksheet Functions |