Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column reference after string found
Hi all, i need to find a string on a spreadsheet and once found i need
to get the column that it is in. Could anybody help me with some code please ? I have the find string code, i just need to know how to get the column that the string is in. Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column reference after string found
Let's say you are searching for WW02 and/or WWO3, use this function:
=ADDRESS(MATCH("WW02",A1:A4,0),MATCH("WW03",A1:D1, 0)) The items in quotes are the strings; you can use one or both (I think you only need one for your purposes...) Regards, Ryan--- -- RyGuy "Les Stout" wrote: Hi all, i need to find a string on a spreadsheet and once found i need to get the column that it is in. Could anybody help me with some code please ? I have the find string code, i just need to know how to get the column that the string is in. Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column reference after string found
Showing the code would have been helpful. If that code is finding the Cell
(as a range) that the text is in, then just affix .Column (note the leading dot) after that range to get the column. Rick "Les Stout" wrote in message ... Hi all, i need to find a string on a spreadsheet and once found i need to get the column that it is in. Could anybody help me with some code please ? I have the find string code, i just need to know how to get the column that the string is in. Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get column reference after string found
Perfect Rick thank you so much.
Best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding string and color the found string | Excel Programming | |||
URGENT -- search in string for a value in another column, if found, return value from next column | Excel Programming | |||
Search column - return row found in long text string | Excel Programming | |||
get linenumber when string found in VBE codemodule | Excel Programming | |||
Highlight found text string in cell? | Excel Programming |