Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Worksheet_Change for a range d6:l17 . What I am trying to
accomplish is if 1 is entered in F and a 1 is entered in H both contence is cleared and a 1 is placed on d. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub If Intersect(Target, Me.Range("D6:L17")) Is Nothing Then Exit Sub On Error GoTo CleanUp Application.EnableEvents = False Application.ScreenUpdating = False With Target If Range(Cells(.Row, 6)) And Range(Cells(.Row, 8)).Value = 1 Then Range(Cells(.Row, 6), Cells(.Row, 8)).ClearContents Range(Cells(.Row, 4)).Value = 1 End If End With CleanUp: Application.EnableEvents = True Application.ScreenUpdating = True End Sub ??? Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I switch the contents of 2 cells? | Excel Discussion (Misc queries) | |||
How to switch two data cells ? | Excel Discussion (Misc queries) | |||
Switch calculating cells off | Excel Discussion (Misc queries) | |||
How to switch data between cells? | Excel Worksheet Functions | |||
Is there a way to switch data between two cells? | Excel Discussion (Misc queries) |