Tony,

Thaks so much for the help. It does in fact work like a charm. My
problem was that the way it was set, I needed to be active on sheet2
for it to work. Trying to start it from sheet1 was giving me the
error.

I will take you latest suggestion and try the sligh change, as I would
rather be on sheet1 (output sheet) when running this code.

Thanks again.

Mike


---
Message posted from http://www.ExcelForum.com/