View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default More elaboration on help pages

the Help looks perfectly fine to me -- i see no empty strings. Can you
clarify your problem please?

from Help:

Sets the replacement criteria to use in replacing cell formats.

expression.ReplaceFormat

expression Required. An expression that returns one of the objects in the
Applies To list.

Example
The following example sets the search criteria to find cells containing
Arial, Regular, Size 10 font, replaces their formats with Arial, Bold, Size 8
font, and then notifies the user.

Sub MakeBold()

' Establish search criteria.
With Application.FindFormat.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
End With

' Establish replacement criteria.
With Application.ReplaceFormat.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 8
End With

' Notify user.
With Application.ReplaceFormat.Font
MsgBox .Name & "-" & .FontStyle & "-" & .Size & _
" font is what the search criteria will replace cell formats
with."
End With

End Sub


" wrote:

I just reviewed the example in the Help for ReplaceFormat. Then I
went to the Help for Replace method as applied to a Range object.
From that description, I would never have guessed that providing empty
strings for the What and Replacement "variants" would yield the effect
implied by the ReplaceFormat example. For example, I thought that the
ReplaceFormat would only affect replacement text.

Are there more comprehensive help pages (possibly on the web) on these
classes that elaborate on the terse descriptions in the Help? As a
newbie to VBA, and from experience in other environments, I intend to
rely quite a bit on accurate, comprehensive, and well organized
documentation to figure out how to code. VBA's help seems well
organized, but actual descriptive text seems quite terse and
incomplete. Is there some kind of definitive standard that one could
resort to in order to suss out the subtleties of meaning (which often
aren't very subtle in their coding implications)?

Thanks.