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 |
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 |
All times are GMT +1. The time now is 11:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com