I have a form with some code to store the data in sheet, the code is
Dim irow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
irow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
With ws
.Range("A" & irow) = TextBox1.Text
.Range("B" & irow) = TextBox2.Text
.Range("C" & irow) = TextBox3.Text
.Range("D" & irow) = TextBox4.Text
.Range("E" & irow) = TextBox5.Text
End With
here i can't able to insert the data in empty row in between the data, it will insert the data in last row only even if some rows are empty in middle. Please help me to clear this.
Many thanks in advance
br,
COOL SAB
Bookmarks