View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SOS[_19_] SOS[_19_] is offline
external usenet poster
 
Posts: 1
Default VBA function to return letters of alphabet

Hi All,

I'd be grateful for some help please. I'm looking for a VBA functio
that will return each letter of the alphabet in turn.

I have a query that brings me back all the people in my list whos
surname begins with the letter "A". I know I could run this query 2
times (to return surnames for each letter) but I'd like to be able t
run it with the result of the function passed as a paramater so that
could end up with a table of all my names. The reason I have to spli
it up 26 times is that the query is so big that it falls over if I as
for all names at once.

Hope that makes sense

TIA

Seamu

--
Message posted from http://www.ExcelForum.com