Is there a way of Setting an If loop to search for A-Z without doing A
or B or C or D etc.

I have a column of data and it contains varying things in the specific
colum but im trying to pick out only those that have a single letter in
them.

Heres my code below is there an operator i can put instead of ????????

If Worksheets("Line List").Cells(i, "B") = ("A"??????????"Z") Then

Cheers

James


--
JamesBurrows
------------------------------------------------------------------------
JamesBurrows's Profile: http://www.excelforum.com/member.php...o&userid=35101
View this thread: http://www.excelforum.com/showthread...hreadid=549445