I know I have to use LEN in a loop but I don't know VBA and need this info
asap. can you help?
I know I have to use LEN in a loop but I don't know VBA and need this info
asap. can you help?
for each c in range("a2:a22")
if len(c)>20 then msgbox "Bingo"
next c
--
Don Guillett
SalesAid Software
[email protected]
"pmms" <[email protected]> wrote in message
news:[email protected]...
>I know I have to use LEN in a loop but I don't know VBA and need this info
> asap. can you help?
Try something like this:
For a list of text values, or blanks, in A10: A20
A1: =SUMPRODUCT(--(LEN(A10:A20)>20))=ROWS(A10:A20)
That formula returns TRUE if all of the referenced cells contain values and
the length of those values is greater than 20 characters. It returns FALSE
if any of the cells is blank or has a length of 20 characters or less.
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"pmms" wrote:
> I know I have to use LEN in a loop but I don't know VBA and need this info
> asap. can you help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks