excel - Using VBA to find a string in a specific column

Question

I am new to VBA and using it perform fucntions in excel. I am attempting to search through the A column for a string "Parts Subtotal". Once this string is found within the column, I then want to select the cell that is 13 cells to the right. I know you have to use a combination of the find and offset functions but I nothing I try seems to be working.

标签： excelvba

Answer 1

尝试这个：

Dim Index As Integer = 1

Do Until Range(Index).Value = "Parts Subtotal"
        Index +=1
Loop
Range("N" & Index).Activate