I don't follow how you define the Range. Why haven't you used snb's code, it will be much faster