ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple change events on same sheet (https://www.excelbanter.com/excel-programming/346935-multiple-change-events-same-sheet.html)

JG Scott

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.



All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com