I am new to Excel VBA and I would need your help for the VBA code
I have two spreadsheets One Named “January” and “Registry”
If value in Cell “D3” Of Registry Matches Any Cell in “January” Spreadsheet, It will clear Contents of Cell E6:AJ6 in “January” Spreadsheet
Much Appreciated for your help.
3
This is one workaround:
If Not Worksheets("January").Cells.Find(Worksheets("Registry").Range("D3")) Is Nothing Then
Worksheets("January").Range("E6:AJ6").Clear
End If