Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic FindValue Q. "Find lword starting with A"
I made (Read: Someone in here told me how to make) a function that wil
search for a given word in a sheet. Now I need a function to search aphabetically through a colomn, so if Click on "A" it will go down to the first name starting with A... Anyone -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic FindValue Q. "Find lword starting with A"
Edit = Find
A* -- Regards, Tom Ogilvy "kandinsky " wrote in message ... I made (Read: Someone in here told me how to make) a function that will search for a given word in a sheet. Now I need a function to search aphabetically through a colomn, so if i Click on "A" it will go down to the first name starting with A... Anyone? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic FindValue Q. "Find lword starting with A"
Hi
try the following macro (and assign it to a button): dim rng as range dim c as range set rng = range ("A:A") for each c in rng if left(c.value,1)="a" then c.select exit for end if next -- Regards Frank Kabel Frankfurt, Germany I made (Read: Someone in here told me how to make) a function that will search for a given word in a sheet. Now I need a function to search aphabetically through a colomn, so if i Click on "A" it will go down to the first name starting with A... Anyone? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic FindValue Q. "Find lword starting with A"
For me, that only results in going to the first word that INCLUDES th
letter A. It doesn't go to the first word that STARTS with the lette a. I want it to take me to the first cell in the colomn, that wiic contains a word that starts with the letter A. (And only in a specifi Colomn, ike fx B -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Basic FindValue Q. "Find lword starting with A"
You also need to check
Entire Cells Only then it will find the cell that starts with the letter A. -- Regards, Tom Ogilvy "kandinsky " wrote in message ... For me, that only results in going to the first word that INCLUDES the letter A. It doesn't go to the first word that STARTS with the letter a. I want it to take me to the first cell in the colomn, that wiich contains a word that starts with the letter A. (And only in a specific Colomn, ike fx B) --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
How do I replace decimals starting with "." to "0." in excel? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |