Find method
 

benb wrote:

I want to search an entire sheet for a cell containing a value then return
the column number for that cell. I have tried variations of
n=Activesheet.Find ([value], LookIn: xlValues, LookAt: xlWhole).Column, but
any adaption I try gets a compile error. Any help?

Three changes will fix your code:

n = Activesheet.Cells.Find ([value], LookIn:=xlValues, LookAt:= _
xlWhole).Column

Alan Beban