Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find column name/number of a value in a row
Hi all,
I would like to find a certain value in a row, like row 7, and put th column name or number on a variable. What is the script for doin this? thanks! Sinobat -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find column name/number of a value in a row
vRowNum = 7
-- Regards, Tom Ogilvy "Sinobato " wrote in message ... Hi all, I would like to find a certain value in a row, like row 7, and put the column name or number on a variable. What is the script for doing this? thanks! Sinobato --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find column name/number of a value in a row
Tom,
I'm sorry if I was not clear. What I wanted to do is, let's say, I hav several data on several columns but on a single row only, ie. A7, B7 C7, D7, E7, etc. Now, I would like to find a data along this row an once found, get the column name/number so that I can use it later on m script. Do I have to iterate through all the column, or can I do i using the FIND command? Thanks, Sinobat -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find column name/number of a value in a row
All,
Thanks for your replies! This forum is such a hit with people lik you! Kind regards, Sinobat -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FInd common data in one column then add number in adjacent column | Excel Worksheet Functions | |||
Find previous number and find next number in column | Excel Discussion (Misc queries) | |||
How to find what number in Column A is not included in Column B? | Excel Discussion (Misc queries) | |||
How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Find First and Last Row Number in Column | Excel Programming |