View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Properties returning object reference or value?

Bold is a property of the Font object. The Boolean value of Bold is either
True or False. It has nothing to do with the Range Object.



wrote in message
...
In the Help for Font Object, there is this example code:

Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

The help also says that the Font property returns a Font object.
Assuming that the property returns a value rather than a reference,
I'm imagining an actual construct that exists apart from the range
itself, containing fields that describe the font(s) used within the
range. I'm trying to understand how assigning a True to one of the
member fields in the Font object (the Bold field) causes True to be
propagated back to the actual range cells. In C++ vernacular, has the
assignment operator "=" been overriden?

Thanks