Hello,
I have userform inserting data to sheet:
lastrow = Worksheets("1.-3.").Cells(Rows.Count, 1).End(xlUp).Row
Worksheets("1.-3.").Cells(lastrow + 1, 1).Value = TextBox2.Text
Worksheets("1.-3.").Cells(lastrow + 1, 2).Value = TextBox1.Text
Worksheets("1.-3.").Cells(lastrow + 1, 3).Value = TextBox3.Text
Worksheets("1.-3.").Cells(lastrow + 1, 13).Value = TextBox2.Text
EDIT:
And i need to automatically create new line after last row in column A with merged cells from C to J, how can i make it. Please help someone?
I have userform inserting data to sheet:
lastrow = Worksheets("1.-3.").Cells(Rows.Count, 1).End(xlUp).Row
Worksheets("1.-3.").Cells(lastrow + 1, 1).Value = TextBox2.Text
Worksheets("1.-3.").Cells(lastrow + 1, 2).Value = TextBox1.Text
Worksheets("1.-3.").Cells(lastrow + 1, 3).Value = TextBox3.Text
Worksheets("1.-3.").Cells(lastrow + 1, 13).Value = TextBox2.Text
EDIT:
And i need to automatically create new line after last row in column A with merged cells from C to J, how can i make it. Please help someone?

Last edited by a moderator: