Question about ).End(xlToRight)
wbk1.Sheets(1).Cells(i, j).Value = _
wbk2.Sheets(1).Cells.Find _
(SEARCHKEY).Offset(0,1)
End(xltoRight) would be the same as hitting end and right arrow from the
found cell.
Where it ends up would depend on what in the cells to the right.
--
Regards,
Tom Ogilvy
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
|