View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rich Rich is offline
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.