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: 298
Default Code to Delete Data in Specific Cells

Hi Everyone,

I was wondering if you could help me with some Excel Coding

The following is what I am trying to Achieve. Please note that I only want
it to happen on the Active Sheet, not on any of the other sheets

If P23 is updated, then clear the data in cells S23, T23, U23, V23, W23,
X23, Y23, Z23, AA23 or (S23:AA23)

If S23 is updated, then clear the data in cells V23, W23, X23, Y23, Z23,
AA23 or (V23:AA23)

If V23 is updated, then clear the data in cells X23, Y23, Z23, AA23 or
(X23:AA23)

If X23 is updated, then clear the data in cells Y23, Z23, AA23 or (X23:AA23)

I will actually want to apply this same function in rows 23 - 42 so if
there is some sort of short cut that applies the code to all rows that would
be great.
 
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
Delete cells containing specific data? Mobility Guy Excel Discussion (Misc queries) 1 March 22nd 07 08:29 PM
macro to select cells containing specific text and delete all cells but these JenIT Excel Programming 3 March 27th 06 10:07 PM
how to delete contents of cells having specific data steve Excel Discussion (Misc queries) 2 July 20th 05 10:42 PM
Worksheet Change code not running when you just delete data in cells. KimberlyC Excel Programming 0 June 23rd 05 01:43 AM
Delete specific cells contents in a row with some locked cells in the same row trussman Excel Programming 2 March 1st 05 06:12 PM


All times are GMT +1. The time now is 09:43 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"