Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I received answers to this, but can't figure out how to use them with
the code I already have, which is: Private Sub Worksheet_Change(ByVal Target As Range) For Each Cell In Range("c52,E52:e63,e68:e75,e84:e99,c84:c99") If Cell.Value = "" Then Cell.Value = 0 End If Next Cell End Sub How can I retain this and add other change events on this sheet? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine 2 worksheet change events | Excel Discussion (Misc queries) | |||
Cell change events | Excel Discussion (Misc queries) | |||
Multiple change events on same sheet | Excel Programming | |||
Change events and linked cells | Excel Programming | |||
Excel 97 - Inconsistent Change Events | Excel Programming |