Hi everyone,
Now I writting a VBA function in Excel, firstly I use ADO to read the
data in table into data array in Memory.
I found in some case the function is running will, some case the
function go to deadlock. I check the situation in case deadlock, I found I
read a huge data into data array, then the function run very slow and go to
dead lock.
anyone know whether MS has memory restriction of data array? if so, do
I need control the data size which need read into array??

thanks in advance :)