Check your previous thread.

Barb Reinhardt wrote:

I am using a worksheet change event and am getting row and column data from
the target value. What I want to do is get the value that is in the
following location and ultimately use it in A VLOOKUP. What am I doing
wrong?

Set Value.address = "R" & Target.Row & "C" & (Target.Column + 1))

This value will be used as a constant in an

Application.WorksheetFunction.VLookup() function



--

Dave Peterson