Thanks, That worked, don't understand why, but thats OK!!!!!!

I was wanting to remove the loop
For Each sh In Workbooks("detailed report.xls").Worksheets

Could you tell me what needs to be deleted. I want it to search only
sheet1

Thanks,
Ron