View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Use VB to move to adjacent cell

I need to become a lot faster to beat Dave and Chip!
__________________________________________________ ______________________

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
If your VB code identifies a cell:

rngFoundCell.Offset(, 1).Select

If it just selects a cell:

ActiveCell.Offset(, 1).Select

__________________________________________________ ______________________


"Bstice" wrote in message
...
Hello,

I know that this is a simple question, but I can't find the answer. I
have
the VB code to find a cell in a worksheet. I would then like to have the
adjacent cell to the right highlighted. What is the code for that?

Thanks
B