| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adapt code to show filter
I have the following code -
Private Sub Search_Clothing_Click() Worksheets("Sheet1").Range("DP:DP").AutoFilter _ field:=1, _ Criteria1:=clothing.Text 'This performs the filter on any text that is in the Clothing text field End Sub When i run the search it works fine, but the user cannot see the filtered cells withour scrolling left or right. Can i add a line which says go to DP so that the row appears in the top left of the screen? I am sure this is easy but i can't get my head round the syntax. Any help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adapt code to show filter
Hi Jack,
Try: Application.Goto Reference:=Range("DP1"), Scroll:=True --- Regards, Norman "Jack" wrote in message ... I have the following code - Private Sub Search_Clothing_Click() Worksheets("Sheet1").Range("DP:DP").AutoFilter _ field:=1, _ Criteria1:=clothing.Text 'This performs the filter on any text that is in the Clothing text field End Sub When i run the search it works fine, but the user cannot see the filtered cells withour scrolling left or right. Can i add a line which says go to DP so that the row appears in the top left of the screen? I am sure this is easy but i can't get my head round the syntax. Any help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adapt code to show filter
Works like a dream. Thanks!
"Norman Jones" wrote: Hi Jack, Try: Application.Goto Reference:=Range("DP1"), Scroll:=True --- Regards, Norman "Jack" wrote in message ... I have the following code - Private Sub Search_Clothing_Click() Worksheets("Sheet1").Range("DP:DP").AutoFilter _ field:=1, _ Criteria1:=clothing.Text 'This performs the filter on any text that is in the Clothing text field End Sub When i run the search it works fine, but the user cannot see the filtered cells withour scrolling left or right. Can i add a line which says go to DP so that the row appears in the top left of the screen? I am sure this is easy but i can't get my head round the syntax. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Several Pivot Tables: Change one filter and adapt it for the other | Excel Discussion (Misc queries) | |||
| Adapt code to loop through sheets | Excel Programming | |||
| Using Find/Replace in Visual basic to adapt the code | Excel Programming | |||
| How can I adapt the included filter example to search for more th. | Excel Discussion (Misc queries) | |||
| Please help me to adapt this code. | Excel Programming | |||
Hybrid Mode
