sorry to bother with question, but I can not find any solution for my issue no matter what I try. What I would like to do:
- look at range in colum A in sheet1 which can vary in number of lines. All cells in Worksheets("Sheet1").Range("A:A") contains text. 
- take sheet1 range and for all cells in that range look at range in sheet2 Worksheets("Sheet2").Range("A4:Axx") number of lines may vary also and starts at A4. 
- then if the cell text from range1 match in cell of range2 then I need to keep that line and rest of lines in range2 (A4:Axx) what A colum value dont match the A column from sheet1 should be deleted. 
I study it a lot lately but it is beyond my capability :(
I suppose it will be based on "For Each c In Range1" find ..... but since there are 2 ranges in different sheet and not single values - I am stucked.
Really appreciate any help. Thank you a lot in advance.
Here is the code I find out:
Sub KRITICKE_LH()
        Dim A As String
        Dim BODY As Range
        Dim CMM As Range
        Dim F As Range
    
    Application.ScreenUpdating = False
    
    Sheets("3D LH").Select
    Range("A4").Select
    Range(Selection, Selection.End(xlDown)).Select
    Set CMM = Selection
    Range("A4").Select
    
    Sheets("BODY CAP").Select
    Range("A1").Select
    Range(Selection, Selection.End(xlDown)).Select
    Set BODY = Selection
    Range("A1").Select
       
                
        For Each c In CMM
            If IsError(Application.Match(c.Value, _
            BODY, 0)) Then
                If F Is Nothing Then
                    Set F = c
                Else
                    Set F = Union(F, c)
                End If
            End If
        Next
            
        If Not F Is Nothing Then F.EntireRow.Delete xlUp
Application.ScreenUpdating = True
End Sub
 
    