old error with original code is method range of object _worksheet failed

hope that helps

i don't want to over write data but append to the bottom before dedicating it