Basic FindValue Q. "Find lword starting with A"

K

kandinsky

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
 
F

Frank Kabel

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
 
K

kandinsky

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
 
T

Tom Ogilvy

You also need to check

Entire Cells Only

then it will find the cell that starts with the letter A.
 
Top