I made a named range that uses indirect to return a table with about 43K objects in it. Im beginning to understand that it is taxing Excel incredibly since I use the data from the table in many calculations on my worksheet. How would I implement the
Choose function into this formula:
=INDIRECT("'"&'Loss Template'!$S$33&"'!"&"$A$1:$M"&COUNTA(INDIRECT("'"&'Loss Template'!$S$33&"'!"&"A:A")))
I'm trying to see if this will help my file not use 18 GB to calculate my workbook whenever I run a macro where that indirect named range changes constantly.