Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel: new list from cells in a range
Hello, say i have a range of cells on sheet1: A1:E10. i'd like to copy the value of any cell where the "LEN" of the value in that cell is greater than 6 and less than 9, and create a single colum list of those values on column A of sheet2. the direction (seach by rows or columns) and sort order...- yingxyang
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
