Bob, end(xltoright) does the same thing as presing the End key and the right
arrow.
To specify one cell to the right use .Offset(0,1)
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"Bob Benjamin" wrote in message
...
In the line below what does End(xlToRight) mean?
wbk1.Sheets(1).Cells(i, j) _ = wbk2.Sheets(1).Cells.Find _
(SEARCHKEY).End(xlToRight)
If there a way to change "End(xlToRight)" in this line to
mean the cell at the same row as the found cell but in the very next
column?
Any help would be appreciated.
Bob