I am hoping that you read this once more because clearing your range is very permanent. As far as I know, there is no recovering from that unless you close without saving. Not that I am trying to be nosy but is your data being logged somewhere else, or does it even need to be? Also, is the range that you used in post # 5 a fixed permanent range the will never increase? If it is not fixed we can change the code a bit to allow for a change in the range.

More importantly and to reiterate, be sure that the data you clear is 100% "OK" for clearing.

Regards: