My excel file contains approx 16000 rows.
I need to go through all the rows and perform various actions on each row(usually assigning rows to variables, cutting numbers, etc.)
I’m using For Each row, but that takes a lot of time (almost 45 minutes for all rows) which is unacceptable.
What could be a faster and more efficient way?
Thanks in advance.