Oh sorry its a misunderstanding, i changed the output to apend, i thought i needed to have output as this creates a file, and thought apend does NOT create a file if there is no file in the directory.

The help i needed was my current records get saved between a1 and a16, and if i run the userform again and save the records again more records get saved between a17 and a32. I do not want this to happen i want the new records to get saved in to the next cell which is b1 and b17, and if i run this again the next save to happen between c1 and c17. I hope you understand now.