LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine 2 worksheet change events nobbyknownowt Excel Discussion (Misc queries) 0 May 28th 10 10:49 AM
Cell change events Richard Excel Discussion (Misc queries) 2 May 16th 07 04:18 PM
Multiple change events on same sheet JG Scott Excel Programming 4 January 19th 06 03:56 AM
Change events and linked cells Don Wiss Excel Programming 1 July 2nd 04 10:15 PM
Excel 97 - Inconsistent Change Events TightCode Excel Programming 0 July 31st 03 06:00 PM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"