AnsweredAssumed Answered

Multiple array resize at same time

Question asked by wer59 on Oct 6, 2015
Latest reply on Nov 25, 2015 by Marcos Vainer Loeff


I have a spreadsheet that on "auto open" resizes arrays through the dlresize function.  There are about 9 separate arrays that resize. During the open sequence the sheet focuses on each range and does its auto size function wonderfully. The question I have, Is there a way to  resize all the arrays at the same time, vice the code to call resize after each range? The next question, I would like to open a simple splash screeen while these arrays resize, until they are done, then the splash screen would close and the spreadsheet will open. Does anyone have some basic code that i might mimic to show a splash during resize ? Thank you for the support.