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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ASHRAE2007
- Order by date
-
How do I put a copy and paste command into an Excel VB Do loop
Guess I have solved teh first part of the problem. Still need help on the second part ie. I may have a situation wher the exact match is not found in this case i want it to find 5 or 10 of the closest values close to 2.5. Sub testloop() Sheet2.Cells.Select Selection.Delete Dim r As Long...- ASHRAE2007
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How do I put a copy and paste command into an Excel VB Do loop
Hi i'm a beginer with VBA. I have a situation where data in a folder Sheet1 has 4000 rows. The value i am lookingup in this eg is "2.5". Upon finding this data I wanted the program to copy the whole row and paste it into sheet2. The peoblem is "2.5" is repeated more than once. So i need the...- ASHRAE2007
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
