Excel developers mindset
There is an alternate method, FontStyle:
Worksheets("Sheet1").Range("A1").Font.FontStyle = "Bold Italic"--
Regards,Tom Ogilvy"GB"
wrote in message ...
I am still trying to understand the thinking behind certain things in VBA.
Can anyone explain why to make a cell bold and italic the following is
done:
Range("A1").Font.Bold = True
Range("A1").Font.Italic = True
Rather than:
Range("A1").Font = xlBold + xlItalic
I can see that Bold is just one of the properties of the font and you
either
switch it on or off. So the way it is implemented is absolutely logical.
But
why is the other way of doing it illogical then?
Geoff
|