View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default I HAVE SAY INFO ACROSS 10 COLUMNS. HOW TO MAKE THE COL-A CELL ACTIVE WHEN U HIT 'ENTER'

DEAR ALL
For example - data entry is being made and say info is across 10
columns. How to make the cursor/cell active from COL_J to the next
row at COL_A when 'ENTER' is pressed. I can make it go only to right
or down but not down and 10 cells to the left. I have used macro
using ctrl-left arrow etc. But i am sure some better way must be
there. Pls adv