Thread: Findformat
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Findformat

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.

--
Regards,
Tom Ogilvy

"Steffen" wrote in message
...
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