find in which column is the value

[2much4u]

hi
in need to find a column number which contains the value specified
there certainly is only one column like that in the chart

i'm trying this:

Dim c1 As Long
Dim p1 As Range
Set p1 = Worksheets(1).Range("b1:cv1").Find("hi", LookIn:=xlValues)
c1 = p1.Column

Debugger stops at the last line with error:
Object variable or With block variable not set

i just need to identify the column starting with "hi" to use its other rows

thans for any help!

 

[2much4u]

...it's in excel

 

[SkipVought]

Hi,

Dim c1 As Long
Dim p1 As Range
Set p1 = Worksheets(1).Range("b1:cv1").Find("hi", LookIn:=xlValues)
if not p1 is nothing then _
   c1 = p1.Column

Skip,
[sub]
[red][/red]
[/sub]

 

[2much4u]

thanks

works