S
seans
hey i'm new to vba this seems easy enough but i'm struggling
in cell Q1 the value is chosen from a list about 40 names
each time I change a name I need a macro to run called delete_cells which
clears the values "w" or "l" from the cells . I have the code for
delete_cells below
Sub delete_cells()
Cells.Select
Selection.Replace What:="w", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="l", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Thanx in advance
in cell Q1 the value is chosen from a list about 40 names
each time I change a name I need a macro to run called delete_cells which
clears the values "w" or "l" from the cells . I have the code for
delete_cells below
Sub delete_cells()
Cells.Select
Selection.Replace What:="w", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="l", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Thanx in advance