On Jul 30, 10:13*pm, "Jim Cone" wrote:
Please report your results.

I still haven't found a solution to my initial problem
however by using Removing "Cells.Clear" has solved the second one.

My file is running fine except when I go to update and it updates all
the files again.

is there a way to put code in that picks up new updates from the save
date of the document register.

eg if I save the document register today, the next time i open it, the
program looks at that date and updates newly added documents from the
folder?