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 dencom 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 PoohBear2000
-
Howso I sort a range based on partial text in a cell
Thanks! That worked perfectly!- PoohBear2000
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Howso I sort a range based on partial text in a cell
I have a range in which the first column holds FPDN 5xx or PDN xxx numbers. How can I filter so that I show only FPDN items, regardless of what number follows them? This is my code at this point. Dim R As Range, Cel As Range Set R = Range("PDNNum") For Each Cel In R If Cel.Value <> "FPDN"...- PoohBear2000
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
