| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macro on Change
I have the following code in Sheet1. When I change data in cell D5, it
invokes the FindInv macro. If I then try to clear a range of cells in Sheet1, say D3:D4, the code below runs again and I get a type mismatch error. What do I need to do to prevent this? Private Sub Worksheet_Change(ByVal Target As Range) If Target = Range("D5") Then FindInv End Sub Thanks. -- Ken Hudson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
| Insert row at change macro - how to change it. | Excel Discussion (Misc queries) | |||
| macro that will change the font of a cell if i change a value | Excel Discussion (Misc queries) | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
Threaded Mode
