software

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: quot;1quot;)
2) retrieve header for that column (result: quot;iquot;)
3) find the next value in the range A9:L9 (result: quot;8quot;)
2) retrieve header for that column (result: quot;lquot;)

Best Regards,
Elio -------------------------------------------------------------------
|Filename: FirstValueInaRow.pdf |
|Download: www.excelforum.com/attachment.php?postid=4240 |
-------------------------------------------------------------------

--
efernandes67
------------------------------------------------------------------------
efernandes67's Profile: www.excelforum.com/member.php...oamp;userid=17916
View this thread: www.excelforum.com/showthread...hreadid=502585In a standard module paste in:

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

quot;efernandes67quot; wrote:

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