Selecting a cell next to the current cell in excel

I'm doing a small vba in excel which change the value of blank cells to "NO DATA". This is what I've done so far:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo hell:
Application.Goto reference:="DBtable"
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.SpecialCells(xlCellTypeBlanks).Value = "NO DATA"

'I DON'T KNOW WHAT TO PUT HERE

hell:
End Sub

What I would like to happen is that, whenever I add a new record on my table and it contains a blank cell, it should be changed immediately with the "NO DATA" value and then the selection should be on the next cell of the last cell I modified. What's happening right now is that after it change the blank cell to the value I want, it selects the whole table. Please help me!

Recent Questions...