| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtering worksheet in VBA
Thank you Dave, it works prefectly.
"Dave Peterson" wrote: Check the name of the worksheet that owns the change: Option Explicit Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Select Case LCase(Sh.Name) Case Is = "sheet1", "sheet2", "sheet3" 'do something Case Is = "sheet5", "sheet4", "sheet6" 'do something else Case Else 'do nothing or something else completely End Select End Sub RaY wrote: Hi, I have got this situation. I made a macro that will be auto run after a column has been updated. I am using Workbook_SheetChange in ThisWorkbook. Since I need to update 12 sheets with that macro so that I put it in there. The problem is.... the marco will be run in the other unnecessary worksheet too. Is there a method or way to return a value of the current worksheet and let the code determine not to run that marco when that sheet is selected? Regards, Ray -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Filtering by UserName | Excel Worksheet Functions | |||
| filtering a worksheet to print | Excel Discussion (Misc queries) | |||
| multiple worksheet filtering | Excel Discussion (Misc queries) | |||
| HELP!!! Advanced Filtering to another Worksheet | Excel Programming | |||
| filtering out data using other worksheet | Excel Programming | |||
Hybrid Mode
