HorizontalAlignment Error in Excel 97

[Werner]

Hi,

I have a HorizontalAlignment line code that doesn't want to work. It
says : "Error '1004' : Unable to set the HorizontalAlignment property
of the Range class.". I am in Excel 97 and it is frustrating not being
able to do such a simple task with VBA. It shouldn't be difficult.
Cells are not even merged. Any ideas?

Werner


Code:
--------------------


Worksheets("Formulaire").Range("A6:AE11").Select
With Selection
.HorizontalAlignment = xlLeft
End With

 

[Guest]

Try this:
..HorizontalAlignment = xlHAlignLeft

 

[Werner]

It works! Thanks a lot!

Regards,

Werner