Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Findformat
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FindFormat with Borders not Working | Excel Discussion (Misc queries) | |||
FindFormat | Excel Programming |