Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the first Value in a Row and Retrieve the Header for That Column
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the first Value in a Row and Retrieve the Header for That Col
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|