Formatting is always time consuming if you are doing it by cell o
range.

I save a lot of time by using Copy/Paste instead - sometimes eve
having a hidden sheet containing ready-formatted ranges

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