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

--------------------


--
Werner
------------------------------------------------------------------------
Werner's Profile: http://www.excelforum.com/member.php...o&userid=24304
View this thread: http://www.excelforum.com/showthread...hreadid=392946