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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can't See the Forest for the Trees !!!
Hello: My script does almost everything I want. I pick the file I'm going to copy with the UserAccounts Dialog. This file name is xclude.txt I'm writing this out to another folder and adding a incrementing number to the end so I have multiple copies depending on what the user enters into the... -
Transpose problem
Skip: That is an ingenious formula. Thank you so much. Sometimes you can think for hours and just get lost. Now I don't have to have the user select anything. Have 2 stars. z2Gary- z2gary
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Transpose problem
Skip: Your right. Sometimes can't see the forest for the trees. Thanks for the response anyway. z2Gary- z2gary
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Transpose problem
Skip here is the data. The program transposes these addresses from column "A" sheet 1 to A B C on sheet 2. Mr. David Lebeau 3l71 Laubert Road Atwater, OH 44201-9792 Christine & Thomas Knippenberg Hiram, OH 44234 Tina Creedon P.O. Box 2012 196 Critchlow Sch. Road Renfrew, PA 16053 There are...- z2gary
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Transpose problem
Hello: The following code was written by Geoff and I copied it to a module in my Excel 2000. It works perfect. I need help with modifing it to work with my scenerio. I need the user to select the range in column "A" because the addresses are not consistant. Most are 3 rows long without blank...- z2gary
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
