Hi,

I have the same problem too.

At the moment I have these cells (2 rows and 5 columns):

A B C
D E
Bangladesh (Bangladesh Taka)* TRUE Bangladesh
Chittagong (Agrabad, St. Martin, 108 7,380 FALSE Sonargaon)
Peninsula) TRUE Peninsula)

* A1 is bold

My D column evaluates =EXACT(A1,"") such that for every new country, in this
case Bangladesh, if D1 is true E1 will copy the name of the new country.

the problem arises in the third line: Since I have to copy all the countries
in this database, some lines take more than one line space such in this case
and when I use my formula E3 gets the name of A3. Yet, this is a flaw I am
trying to fix testing for bold in the cell A3. I am using
IsBold(A3,A3.Font.Bold) but it does not work.

Any suggestions?

Thanks a lot