G
Gregor
From a performance stand point, which of these is better:
Range("A66").Font.Bold = True
Range("A66").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
Range("A66").Font.Bold = True
Range("A66").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