Forum Discussion
Excel workbook hangs up when vlookup vba is executed
I have coded a simple vlookup vba code; it works but whenever i try to execute it, the whole workbook got hanged. Is there any way to fix this? Vlookup is executed with 244k rows of data. Su...
I notice that lastRow is the last used row on Sheet2 in the workbook that you open.
But you use it in a loop For i = 2 To lastRow to fill cells on a sheet in the macro workbook. Is that really what you want? You'd be processing 244,000 rows!
HansVogelaar , i know its crazy but is it possible? the reason is because i don't want other to see the formula and wish to lock the column so that no one could amend anything in that column.
But why do you use the last used row on the other sheet in a loop for the sheet in the macro workbook?
HansVogelaar , , lastRow is actually intended for the macro workbook with 244k rows. Hence, the for loop to execute the vlookup from row 2 to the last blank row.
Looping through 244K rows will take a LOT of time!