View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Question about ).End(xlToRight)

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