Hi,

I got this macro where I find a cell with a specific value:

Sub Find_Week()
Application.ScreenUpdating = False

    Sheets("Namn").Select
    Range("B03").Select
    Do Until ActiveCell = vbNullString

 
                    If ActiveCell.Value = Sheets(2).Cells(3, 2) Then
                ActiveCell.Offset(2, -1).Select

 'Some more code here about what to copy and where to paste it :-)

    ActiveCell.Offset(98, 0).Select
               Else
        ActiveCell.Offset(100, 0).Select
    End If
    Loop
Application.ScreenUpdating = True
End Sub
But my problem is. That next time I want to sheck that equal "Sheets(2).Cells(3, 2)" to look in the next row below every time the loop starts over.

I think I need a x value. like:
 
x=3
Sheets(2).Cells(x+1, 2)
But how do I write it?

Or is there any better way?