StartingOut
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 92
Hi not sure what I am doing. the code here will goto the DataBase sheet and find the next row empty and populate the cell across with data, but it starts in column A at row 2, how do I tell it to start in column N in row 16.
Help please
With Worksheets("DataBase")
NextRow = .Cells(.Rows.Count, "A").End(xlUp).Row + 1
.Cells(NextRow, 1).Value = TextBox53.Value
.Cells(NextRow, 2).Value = ComboBox1.Value
.Cells(NextRow, 3).Value = TextBox19.Value
Help please
With Worksheets("DataBase")
NextRow = .Cells(.Rows.Count, "A").End(xlUp).Row + 1
.Cells(NextRow, 1).Value = TextBox53.Value
.Cells(NextRow, 2).Value = ComboBox1.Value
.Cells(NextRow, 3).Value = TextBox19.Value