View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
petedacook petedacook is offline
external usenet poster
 
Posts: 27
Default auto fit & horizontal alignment not working

I have some code that is not centering and formatting all of the columns. I
have coppied the snippet of code that his adjusting the alignment and
autofit. Can anyone tell why the code is not formatting all of the cells?

Columns("A:R").EntireColumn.Select
With Selection.EntireColumn
Cells.EntireColumn.AutoFit
HorizontalAlignment = xlCenter
VerticalAlignment = xlBottom
End With




Thanks!!