Referencing your subject line ... in Excel 97 (my ver), think I can
multi-select non-adjacent cells and apply normal formatting options (via:
Format Cells). But the "Autoformat" option (via Format Autoformat) was
not possible. Excel would display an error msg, saying the command cannot be
performed with multiple selections.

But .. your range "B6:N35" appears to be a single range, in which case
Autoformat option should be available
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brent from the Bahamas" <Brent from the
wrote in message ...
Hi I am trying to apply a range between B6:N35 however whenever I
select B6 , i am told in Microsoft ,version4 page32 to hold the
control
button and select the other cells when i do that and try to apply
Autoformat i get a error message, any advice would be appreciated?