Macro to send cursor to next row of a table in a certain column

[nparsons75]

Hi, I have a table that I need to add new records too. I would like a button named 'New Record' and when this button is pressed, the cursor (cell highlight) will go to the next row in the table, in column C in this case.

Is this possible?

Thanks,

 

[Peter_SSs]

It depends partly on whether your table is a formal excel table or not and whether there are any gaps in your data in column C.
See if one of these suits you better than the others.

Sub GoToNewRecord1()
  Range("C" & Rows.Count).End(xlUp).Offset(1).Select
End Sub

Sub GoToNewRecord2()
  Range("C1").End(xlDown).Offset(1).Select
End Sub

Sub GoToNewRecord3()
  Columns("C").Find(What:="?*", SearchDirection:=xlPrevious, SearchFormat:=False).Offset(1).Select
End Sub

 

[nparsons75]

Brilliant, first option works great, thank you for your time