Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Worksheet Change" Question
I am using the following code to run a macro if the data
in this cell (E26) is changed. I want another cell on the same worksheet to do the same thing. (E28). I tried adding another "worksheet change" but it didn't like it, evidently you can only have one per sheet. How do I add the other cell into the mix? Thanks Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E26")) Is Nothing Then Sheets("Entry").Select Application.Run "CopyFilterData5" End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Worksheet Change" Question
Mike,
Try this Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E26,E28")) Is Nothing Then Sheets("Entry").Select Application.Run "CopyFilterData5" End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "documike" wrote in message ... I am using the following code to run a macro if the data in this cell (E26) is changed. I want another cell on the same worksheet to do the same thing. (E28). I tried adding another "worksheet change" but it didn't like it, evidently you can only have one per sheet. How do I add the other cell into the mix? Thanks Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E26")) Is Nothing Then Sheets("Entry").Select Application.Run "CopyFilterData5" End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
=IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming |