Hello all,

Running Office 2003 Professional Excel build 11.5612.5703 on XP sp2.

If VerticalAlignment is set to xlTop on a range of cells, and there are
indented cells it also removes the indent. If the property is set via the
UI, the correct indents are maintained.

To duplicate:

1. Enter text into a couple of cells.
2. Add a couple of indents to the cells.
3. Create and run the following macro:

Sub Test()

ActiveSheet.Cells.Select
Selection.VerticalAlignment = xlTop

End Sub

All of the indents will be removed. Wassup? Any help would be greatly
appreciated.

TIA,

Bill