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...
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!
- I guess the only way is to manually enter in the formula. Thanks for the help anyway! Much appreciated!