Hello
Can anyone please modify the below snippet for below;
-presently for an ex. TextBox7 value will be pasted in row#8 but I need that value to be pasted all the visible cells under row#8.
Can this be done with the existing code or loop needed ? pls help
Can anyone please modify the below snippet for below;
-presently for an ex. TextBox7 value will be pasted in row#8 but I need that value to be pasted all the visible cells under row#8.
Can this be done with the existing code or loop needed ? pls help
Code:
erow = Sheets("Main Database").Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row
Cells(erow, 8) = TextBox7.Text
Cells(erow, 14) = txtPhone.Text
Cells(erow, 32) = ComboBox6.Text
Cells(erow, 37) = "Modified"