If you go to the first cell hold down the mouse button and drag your
range to the last cell to select autoformat should work

Alternatively click on the first cell, press the shift key, then click
on the last cell yhen choose autoformat

by clicking on cells with control, you are selecting lots of seperate
ranges even tho the cells are next to each other, hence autoformat will
not work


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=503625