Close and Quit Excel Eureka"

R

rogge

After reading ALL of the posts for closing excel, this is what i found:

After opening the excel file and using this code, Excel remains "open"...

xlBook.Worksheets(i).Activate
Range("1:1").Select
Selection.Font.Bold = True
With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid
End With

But when swithing to this code, Excel closes...

xlBook.Worksheets(i).Range("1:1").Font.Bold = True
xlBook.Worksheets(i).Range("1:1").Interior.ColorIndex = 15
xlBook.Worksheets(i).Range("1:1").Interior.Pattern = xlSolid
xlBook.Worksheets(i).Range("1:1").AutoFilter

Changing this code caused EXCEL(s at causing troubles) to close....
 
Top