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 gkittelson 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: rabingupta
- Order by date
-
Code Optimization Request
Hi Combo, I am sorry I am required to use code as there are further things associated with this task. Is it possible to convert the for loop in a code based vlookup??- rabingupta
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Code Optimization Request
Hi Guys, I would highly appreciate if you can help me to optimize my code. My Problem: Compare Col A (Total Rows = 35000) and Col B (1500) get all the values matching in Row A, where Col C = "Y". I have this code but its taking too long to run, Please help me optimize the code. My Code...- rabingupta
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Compare Range A & B where C = "Y"
Dear All, I have this small macro code written but there are couple of queries which I have got: 1. It is very slow 2. The value given by Vlookup is not same as the macro code being executed. Please help!! My Code: Dim ForIndex As Integer Dim ForIndex1 As Integer Dim Counter As Integer...- rabingupta
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
