Run time error 1004 Application-Defined or Object-Defined Error - Placing data into next e

Hi

I am receiving a run time error 1004 Application-Defined or Object-Defined Error onth ecode below. Can anyone point me in the right direction please?

Please Login or Register  to view this content.

Many thanks

Which line error is coming, great if you can upload your workbook

Hi Haripouri, its the first line

Please Login or Register  to view this content.

Seem like you used 1 (one) instead of l (alphabet) in End(xlUp) above. Check and let me know if this is not the case

Thanks Haripopuri,

I was, i have ammended the codeand its executing without errore but its not placing any data in the sheet its definately sheet 9 and the worksheet is called "Archive"

Please Login or Register  to view this content.

Since you are using UserForm, you will have to refer to complete UserForm controls path if you need to use control values. So instead of tbxName.value, try using userform2.tbxName.Value.
Ditto for all others. Let me know if this works.

Cheers
Hari

Just upload your workbook if you still have doubts. That helps a lot to exactly understand what's happening behind the curtains.

Hi Hairipopuri,

Thats not done it either. I have uploaded my spreadsheet. Using the booking button and command button I am trying to archive data from the Client Information Tab to Archive.

Ah!! That will be where it is, how do i start populating empty rows from the top??

Thanks Izandol. I vote for clearing up A. Doesn't look needed much.

Thanks Both, have ammended the code and cleaned up column A as suggested. Thanks for helping me out.