Look here at Chip Pearsons site for some useful code on zoom http://www.cpearson.com/excel/zoom.htm