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 derfloh 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 ryandepriest
-
VB in Excel
You might want to try "case" see the code below. Sub find_instence() Range("D1").Select Range(Selection, Selection.End(xlDown)).Select Selection.Name = "myRange" For i = 2 To Range("myRange").Rows.Count + 1 mycase = ActiveCell.Value Select Case mycase Case "Forced Door" Case...- ryandepriest
- Post #3
- Forum: Visual Basic (Classic)
-
moving files
I have been trying to find a way to move files automatically. The files have a unique key and would need to move to a folder on another drive with the same unique key and if the folder does not exist then creat an folder and loop back tomove the file. I can get the file names into Excel and...- ryandepriest
- Thread
- Replies: 3
- Forum: Visual Basic (Classic)
