Combining Match and Offset in VBA

[Endrik]

I have not received any feedback to my initial question, so I thought I would ask to see if anybody can help me come up with a different solution using a Match and Offset combination in VBA.

I need to be able to search for a certain value in column B, then activate the cell to the right of that value in column C. (Once activated I will be using this code to add a count to the value in column C:

x = ActiveCell.Value
ActiveCell.Value = x + 1

The problem I am having is activating the cell in Column C. Can anyone tell me how to write a function in VBA that would allow me to search the values in Column B, find the value I am looking for, then activate the cell next to it in Column C so I can then increase the count in that cell?

 

[deanst]

Hi - try this.

Sub test()

valToFind = 11

numRow = Application.Match(valToFind, Range("B:B"), 0)

If IsError(numRow) = False Then
    Range("C1").Offset(numRow - 1).Select
Else
    MsgBox ("No Matches")
End If


End Sub

Dean.

 

[Endrik]

Thanks Dean! You are an absolute lifesaver! I have been beating my head against a wall for a week trying to get this to work. Thank you so much for taking the time to reply. Very much appreciated!