my cell range is A2:C2. i need cell range A2:C2 use in blow code instead active cell
how it is correct
Cells(Rows.Count, 2).End(xlUp).End(xlToLeft).Offset(0, i - 1).Select
Range(ActiveCell, ActiveCell.End(xlUp).Offset(1, 0)).Value = Controls("TextBox" & i).Text