View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Coddington Tim Coddington is offline
external usenet poster
 
Posts: 94
Default Excel Formatting Cells Using VB code

I just recorded a macro and go the following:
Cells.Select
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlTop
.WrapText = True
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With
If that's what your asking, hope this helps since I'm not sure about the
HTML part...

"Andrew Price" wrote in message
...
Am fairly new to excel programming,

I am passing in a HTML file to Excel using Style guidelines.

<style
<!--table
@page
{mso-header-data:"&CMultiplication Table\000ADate\: &D\000APage &P";
mso-page-orientation:landscape;}
br
{mso-data-placement:same-cell; mso-word-wrap:true;}
--
</style

Does anyone know the syntax or even if it possible to globally set the

cells
so that the format is

FormatCells.Alignment.TextAlignment.vertical = top
FormatCells.Alignment.TextControl.wordwrap = true

set in the HTML style tags as above.

Thanks in advance

Andrew