FIND code determining wrong value

[rdw72777]

I have the code below that I thought was working but now realize its not.

Input_EstNotes_Col = InputSheet.Rows(myInputHeaderRow).Find(What:="Comments", SearchDirection:=xlPrevious, SearchOrder:=xlByColumns).Column

Becasue I have a column called "Varaince Comments", my find code above finds the first instance of "Comments anywhere in a cell, rather than matching the entire contents of cell. I changed the code to add in the "LookAt:=xlWhole" syntax, but now I just get an error when it hits that line of code. How can i write this line of code to find where teh entire contencts of the cell are the word "Comments"?

Input_EstNotes_Col = InputSheet.Rows(myInputHeaderRow).Find(What:="Comments", SearchDirection:=xlPrevious, LookAt:=xlWhole, SearchOrder:=xlByColumns).Column

 

[VoG]

Try

Input_EstNotes_Col = InputSheet.Rows(myInputHeaderRow).Find(What:="Comments", LookIn:=xlValues, LookAt:=xlWhole).Column

 

[rdw72777]

Done, I actually had done something really stupid but your response mad eme look at the really stupid thing I did...sigh

Thanks.