Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Want entry in column 16 to clear if value in column 12 is = to 10
When entry is made into column 12 as target calls sub pledge following. If target.column = 12 And target.Value = 10 And IsNumeric(target.Value) Then _ Call Pledge(target) Public Sub Pledge(ByVal target As range) Sheets("data").Select target("column = 16").ClearContents End Sub Know I am missing something all entries in same row and will apply thru complete sheet. Reason I believe (target) keeps column row relationship. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clear Contents | Excel Discussion (Misc queries) | |||
clear contents | Excel Programming | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Clear contents | Excel Programming | |||
Clear contents if x is not in the row | Excel Programming |