Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTING AN ITEM FROM AUTO FILTER !
Hi -
In all the sheets of my workbook, I have a list in column Range("B:B"). For each list, I have created an autofilter by manually doing "Data" "Filter" "AutoFilter". This allows me to manually go through each sheet to use the autofilter to select the item I want in each list. I need a macro that will loop through the sheets and just select any item I have already made visible using the autofilter. All the macro will do is just select that visible item in every sheet. Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTING AN ITEM FROM AUTO FILTER !
Please ignore this post....I have used the "hidden" property to solve
the problem and it works neatly! Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SELECTING AN ITEM FROM AUTO FILTER !
Hi Jay
This should do it: Sub SelectFilteredItem() Dim TargetCol As String Dim StartSh As Worksheet Set StartSh = ActiveSheet Application.ScreenUpdating = False TargetCol = "B" For Each sh In ActiveWorkbook.Sheets sh.Activate sh.Range(TargetCol & sh.Rows.Count).End(xlUp).Select Next StartSh.Activate Application.ScreenUpdating = True End Sub If this question is related to your previous post the macro below might be what you want: Sub ConcatenateFilteredItems() Dim TargetCol As String Dim MyString As String Dim StartSh As Worksheet Set StartSh = ActiveSheet Application.ScreenUpdating = False TargetCol = "B" For Each sh In ActiveWorkbook.Sheets If sh.Name < "Display" Then sh.Activate MyString = MyString & sh.Range(TargetCol & _ sh.Rows.Count).End(xlUp).Value End If Next Sheets("Display").Range("D12") = MyString StartSh.Activate Application.ScreenUpdating = True End Sub Best regards, Per "jay dean" skrev i meddelelsen ... Hi - In all the sheets of my workbook, I have a list in column Range("B:B"). For each list, I have created an autofilter by manually doing "Data" "Filter" "AutoFilter". This allows me to manually go through each sheet to use the autofilter to select the item I want in each list. I need a macro that will loop through the sheets and just select any item I have already made visible using the autofilter. All the macro will do is just select that visible item in every sheet. Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting an item from a list | New Users to Excel | |||
Event when selecting an item in a combobox? | Excel Programming | |||
Auto copy/ paste on relevant work sheet when selecting list item | Excel Programming | |||
Selecting a call and using info in auto filter custom select | Excel Programming | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |