Originally Posted by snb Do you guys ever use the search function in this Forum ? Private Sub btnOK_Click() cells(rows.count,4).end(xlup).offset(1).resize(,4)=array(txtFirstName,txtSurName,"snb","much simpler") End Sub I can only speak for myself .... first time I've seen that. Thank you.
Private Sub btnOK_Click() cells(rows.count,4).end(xlup).offset(1).resize(,4)=array(txtFirstName,txtSurName,"snb","much simpler") End Sub
Forum Rules