Good day.
I am new to VBA, and Im assigned to a project which needs some code optimization, currently it uses for loop to read rows one at a time.
Question:
What is the fastest way to search a certain row in 77 or more worksheets with (40000 rows each).
Any help is appreciated. Thanks.