Hello, when I am using the =accountsandsubaccountswithhistory function, I have encountered an error that I was previously not getting, and I am not sure what is causing this.
When I use “*”, or leave blank for BranchorRange, I get an error:
| Connection 'Error! Index was out of range. Must be non-negative and less than the size of the collection. This happened after closing and reopening my workbook, and it was working fine before. Now the only way I can get this function to work appropriately is to designate a specific branch, which is not what I want to do. Has anyone encountered this or know what may be causing it? Function with error:Function when designating a specific Branch: | | | — | |
| — | — |
Any ideas would be much appreciated! Thanks!