Hello everyone,
I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied into VBA memory, so that execution time reduces. ? I am looking forward for any code / supporting link.
Regards
Ruchir Joshi
I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied into VBA memory, so that execution time reduces. ? I am looking forward for any code / supporting link.
Regards
Ruchir Joshi
