| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Common Private Sub
I have 25 same sheets and in everyone is included same Private Sub for cursor
movement. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = "$G$8" Then Range("C9").Select End If .. .. .. If Target.Address = "$D$32" Then Range("I3").Select End If End Sub How can I use this macro as one for all sheets to reduce size of file. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make "common factor" formula ? | Excel Worksheet Functions | |||
| more than 3 conditions in conditional formatting - possible? | Excel Discussion (Misc queries) | |||
| date format problem | Excel Discussion (Misc queries) | |||
| Numbers from seperate worksheet to common sheet | Excel Worksheet Functions | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Threaded Mode
