View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JG Scott JG Scott is offline
external usenet poster
 
Posts: 20
Default Multiple change events on same sheet

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.