Tom, thank you so much it worked...one little question if you don't
mind...I need to add a Paste:=xlValues somewhere in the code because
the data in the cells are actually formulas and I need to paste over
the raw data only.

Thanks again