VBA: searching for data in a column

[jimwilluk]

Hi,

I am trying to write some code to find a particular header cell of a column based on its contents and background colour. Once that cell is found i want to scan down the column for particular text and change the font colour if found.

Here is what I have so far:

Please Login or Register  to view this content.

I think it is finding the header of the column but does not seem to be scanning down (possibly a problem with allocating the column as a range?)

I'm pretty new to VBA so any help would be much appreciated.

[Bob Phillips]

Please Login or Register  to view this content.

[jimwilluk]

That works great, thank you very much.

Only one issue is that the text does not seem to revert back when the button is clicked again in the false state (the else statement not executing?)

[Bob Phillips]

I missed your other error

Please Login or Register  to view this content.

[jimwilluk]

Excellent, thanks alot Bob