I have a macro which populate a worsheet from AutoCAD thru automation. It
worked fine before upgrading to Office 2007. Now it is almost always failing
when I use the selection object to format the cells, for example

WSheet.Range("A1:" & Col & "1").Select

With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Font.Name = "Arial"
.Font.FontStyle = "Bold"
.Font.Size = 10
End With

some times this code works and other times fails. I can't find information
about the selection object. Can someone suggest a better way of doing this?
Thanks.