Re: Search for new line of data, ignoring first column
I tried your suggestion, I get an error 438.
You could also solve my problem in another way - if you tell me the equal command to excel formula CONCATENATE in VBA, so I could put together the values of txtID_N, txtSURNAME and txtNAME.
In that way I could avoid the data in the first column of excel table.
EDIT:
What I'm trying to get is something like:
Code
ws.Cells(iRow, 1).Value = Me.txtID_N.Value + Me.txtSURNAME.Value + Me.txtNAME.Value (with spacing between the values)
ws.Cells(iRow, 2).Value = Me.txtID_N.Value
ws.Cells(iRow, 3).Value = Me.txtSURNAME.Value
ws.Cells(iRow, 4).Value = Me.txtNAME.Value
ws.Cells(iRow, 5).Value = Me.txtJOB_TITTLE.Value
Can you help me with this?
Thank you,
Bojan