Thread: Question about ).End(xlToRight)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Benjamin Bob Benjamin is offline
external usenet poster
  
Posts: 23
Default Question about ).End(xlToRight)
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


Reply With QuoteReply With Quote