Thanks John. I'm still a bit of an idiot on this one. Once I've identified the F column in whatever row I happen to be in. How do I then get the data (I have to put it into another worksheet) in the F column beginning at the active cell for a range of a totals of 10 columns such as F34:O34. The thing is since I never know what row I'll be in, don't know how to active the 10 cells once I find a match on the input parameter.