Findformat

  • Thread starter Thread starter Steffen
  • Start date Start date
S

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
 
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.
 
Back
Top