Findformat

[Steffen]

Has anybody an idea how it is possible to find a certain
cellformat with a find funktion in VBA (no conditional
format though) like "bold"?
Found some info on the net about the existence of
a 'findformat' function, but no details on the code.

Thanx

 

[Tom Ogilvy]

Believe this is an enhancement in xl2002. If you have that, turn on the
macro recorder and do it manually under the edit menu. If you don't then
you would have to loop through each cell and check if the font.bold
attribute is True.