I am trying to write a macro that selects a row if a value in a specified
column meets a certain criteria.

For example, I have a column entitled "YEAR". If the value in this column
is 2005, then I want to select the entire row.

I am able to identify the column and put the cursor in the first cell below
the column header, but I don't know what to write an If Then statement that
will highlight the row if the value is 2005.

The othe problem is that I want to make this macro generic because the YEAR
column is not always in the same location.

Thanks,
Jessica