Thread: RETURN TO C
View Single Post
  #2   Report Post  
Fred
 
Posts: n/a
Default RETURN TO C

How about adding this code to the worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
Cells(Target.Row + 1, 3).Select
End Sub

Good luck!

************************************************** *
eternal_cat via OfficeKB.com wrote:
CAN SOMEONE SLAP ME SOME METHOD THAT ALLOWS ME TO RETURN TO COLUMN C ON THE
NEXT ROW WHENEVER I PRESS ENTER?

THANKS!!!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200510/1