From a performance stand point, which of these is better:

Range("A6:D6").Font.Bold = True
Range("A6:D6").HorizontalAlignment = xlCenter

or

Range("6:6").Font.Bold = True
Range("6:6").HorizontalAlignment = xlCenter

(There will never be any data beyond column D).

I'm using 2007 but keeping the workbook in computability mode.


Thanks
-Gregor