Hi Walter,

Am Fri, 4 Jul 2014 22:20:27 +0100 schrieb Walter Briscoe:

I use Excel 2003.
I have some data, which I intend to mark with a find, findnext loop.
I find that neither bold, nor italic marks work.
I have constructed some fairly simple code by editing a macro I
recorded.
I believe that find should not match a bold cell, but it does. ;(

I had the same problem with xl2007 or later and I could manage it if I
create a cell e.g. Z1 with the expected formats and refer to that cell,
e.g.


With Application.FindFormat.Font
.Name = Range("Z1").Font.Name
.FontStyle = Range("Z1").Font.Fontstyle
.Size = Range("Z1").Font.Size