Hi Tom, for some reason your macro deleted the entire spreadsheet.
Thanks.. Frank, however, yours took a little longer than mine to run. R. Mitchel thanks. still looking at your code.
Ron your code worked as well, however, they all seem to take about 5 minutes to run...

I'll reboot my machine and try each one again. At this point I think I'll use my code.
Thanks again... Very nice info.
DJ