Find the first Value in a Row and Retrieve the Header for That Column

[efernandes67]

Hi,

I need some help solve this problem.
Supose I have the array as in the file in attach.

I want to:
1) find the first value in the range A9:L9 (result: "1")
2) retrieve header for that column (result: "i")
3) find the next value in the range A9:L9 (result: "8")
2) retrieve header for that column (result: "l")

Best Regards,
Elio

[Jim May]

In a standard module paste in:

Sub Foo()
Set Rng = Range("A9:L9")
For Each c In Rng
If c.Value = 1 Or c.Value = 8 Then
MsgBox "Your Header name is " & c.Offset(-8, 0).Value ' assumes your heade
Row = 1
End If
Next c
End Sub

"efernandes67" wrote:

>
> Hi,
>
> I need some help solve this problem.
> Supose I have the array as in the file in attach.
>
> I want to:
> 1) find the first value in the range A9:L9 (result: "1")
> 2) retrieve header for that column (result: "i")
> 3) find the next value in the range A9:L9 (result: "8")
> 2) retrieve header for that column (result: "l")
>
> Best Regards,
> Elio
>
>
> +-------------------------------------------------------------------+
> |Filename: FirstValueInaRow.pdf |
> |Download: http://www.excelforum.com/attachment.php?postid=4240 |
> +-------------------------------------------------------------------+
>
> --
> efernandes67
> ------------------------------------------------------------------------
> efernandes67's Profile: http://www.excelforum.com/member.php...o&userid=17916
> View this thread: http://www.excelforum.com/showthread...hreadid=502585
>
>