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!
Recent content by yingxyang
-
Excel: new list from cells in a range
Thanks Guys, After some tweaking I wound up with this... Sub makelist() Dim Z As Long Z = 1 For Each c In Sheets("Sheet1").Range("A1:E100") If Len(c) < 9 And Len(c) > 6 Then Sheets("Sheet2").Cells(Z, 1) = c Z = Z + 1 End If Next End Sub Thanks for your help!- yingxyang
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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)
