Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete cells containing specific data? | Excel Discussion (Misc queries) | |||
macro to select cells containing specific text and delete all cells but these | Excel Programming | |||
how to delete contents of cells having specific data | Excel Discussion (Misc queries) | |||
Worksheet Change code not running when you just delete data in cells. | Excel Programming | |||
Delete specific cells contents in a row with some locked cells in the same row | Excel Programming |