Quote Originally Posted by vjboaz
That worked absolutely perfectly... I just had to use wks.Name to activate the worksheet.

Thanks so much!!!!

Veronica
You don't need to Activate the sheets to format them.