I need some help with a loop I want to check a range of cells and select only
the cells with a valid product in them for example i want to copy ice cream
but ignore any cells that have nothing in them or have the word product in
them I am trying to use the loop below

If Cells(x, 1).Text < "Product" And _
Cells(x, 1).Text < "" Then
d = x - 1

unfortunately it would appear that the text formatting in each cell hase a
bearing for example product will be selected if the font colour is say blue.
is there anyway around this
--
Jack