Hi Steven

Can't say what is wrong with this code at the first glance as the other works according to you. Could it be a spelling mistake in the string or an extra space in worksheet cells?

By the way if this code is supposed to work on the same file as I made a macro for and if you only wish to set font bold that could be included in my previous code i.e:

Cells(i, 1).EntireRow.Interior.Color = 10092543

Cells(i, 1).Font.Bold = True
Perhaps you could upload a small file sample after removing sensitive information showing how the data look like and how you would like it to look after the change.

Alf