Hello,
I have a macro that has an array code in one cell (Cell C5), and I want to drag that formula a couple of columns and many rows down (around 20,000 rows). The formula takes so long to calculate (and ultimately doesn't ever calculate because I have to quit it). The array formula is essentially looking up a person's name, and finding the different organizations the person is associated with (from a different tab). The array uses the person's name (Column 1), and the number for the array (1,2,3, etc. in row 4). Is there any way to speed it up?
Right now the code is as follows:
"LC" corresponds to the letter of the last column of my data (right now it is "E")
"LR" corresponds to the last row of my data (right now it is 22,091)
Additionally, I have the following codes at the beginning to speed up the code:
Is there any way to make this faster (so that it is actually capable of being run)?
Thank you so much!
Molly
Bookmarks