This formula starts me at D2, need it to begin at cell D18
Private Sub CommandButton1_Click()
Dim rngNext As Range
Set rngNext = Sheet1.Range("D" & Rows.Count).End(xlUp).Offset(1)
rngNext.Value = TextBox1.Value
End Sub
This formula starts me at D2, need it to begin at cell D18
Private Sub CommandButton1_Click()
Dim rngNext As Range
Set rngNext = Sheet1.Range("D" & Rows.Count).End(xlUp).Offset(1)
rngNext.Value = TextBox1.Value
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks