ExcelBanter - RETURN TO C

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - RETURN TO C (https://www.excelbanter.com/excel-worksheet-functions/50733-return-c.html)

eternal_cat via OfficeKB.com

RETURN TO C

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

Fred

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

damorrison

RETURN TO C

Allready did

All times are GMT +1. The time now is 12:40 AM.