Hello all,
The following code "copies" the offset-value it found in column "Y" to cell "Z65".
I'd like it however to resize about 4 collumns to the right and take that range to Z65:Z68, but can't get it done.
Sheets("START").Range("Z65") = Sheets("START").Columns("Y").Find(What:=Sheets("START").Range("W1"), LookIn:=xlValues, lookat:=xlWhole).Offset(0, 1)
Bookmarks