Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
determine if ea value in a col has more than 20 chars
I know I have to use LEN in a loop but I don't know VBA and need this info
asap. can you help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
determine if ea value in a col has more than 20 chars
for each c in range("a2:a22")
if len(c)20 then msgbox "Bingo" next c -- Don Guillett SalesAid Software "pmms" wrote in message ... I know I have to use LEN in a loop but I don't know VBA and need this info asap. can you help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
determine if ea value in a col has more than 20 chars
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine total value of business for sale | Excel Worksheet Functions | |||
In the worksheet_change event, how do I determine what occured? | Excel Worksheet Functions | |||
How to determine second (and then third) highest value in a list | Excel Discussion (Misc queries) | |||
Code to determine if a cell contains an array function? | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions |