offset function not populating - run time 1004 error

[Sc0tt1e]

HR1 is a defined file path to spreadsheet, HR is the name of the Userform, Initials is the name of the textbox within HR.

I am attempting to move down column C if C4 is not empty until I find the last full cell then move down to the empty one below it however I keep getting an error on the last row of the code. Can anyone tell me what I am doing wrong as it's driving me crazy?

Error message is "Application-defined or object-defined error", still trying to understand these error messages.

Please Login or Register  to view this content.

[Sc0tt1e]

This is the full code if it helps

Please Login or Register  to view this content.

[Norie]

The problem is probably because with xlDown you are going right to the last row in the sheet, and then with the Offset trying to move one row beyond.

Where do you want the data to go?

Do you have header rows, for example in row 3?

[Sc0tt1e]

yes, header rows in row 3, data input from row 4 downwards. Want to find the last row with data (below row 4) and insert data below it.

I tried range ("C:C"),xlup but that didn't work either

[Norie]

Try this.

Please Login or Register  to view this content.

Note with this code you really wouldn't need the If that's checking if there is data in row 4.

[Sc0tt1e]

You the man Norie, cheers