Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
which is better?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
which is better?
Hi Gregor
I would rather do it like this: With Range("A6:D6") .Font.Bold = True .HorizontalAlignment = xlCenter End With Regards, Per "Gregor" skrev i meddelelsen ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
which is better?
I don't think there's a difference, but THIS would be better still:
With Range("A6:D6") .Font.Bold = True .HorizontalAlignment = xlCenter End With Bob Umlas Excel MVP "Gregor" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|