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!
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!