Hi
Thanks for your explanation. When I try to run the macro, excel has the following message:" The information cannot be pasted because the copy arean and the paste area are not the same size and shape. try one of the following: - click a single cell, then paste, - select a rectangle that's the same size and shape , and then paste." Please help

Regards
Janmy