I have an xlsm, which contains (among many more) 2 sheets. Both sheets have about 500,000 cells with figures.
A macro runs, which compares each cell(i,j) on both sheets, verifying if the i-j values are the same.
This macro takes some 30 seconds to run.
I would like to show a progress bar, indicating the execution of this macro.
Can anyone indicate how to do this ?
Thanks.
A macro runs, which compares each cell(i,j) on both sheets, verifying if the i-j values are the same.
This macro takes some 30 seconds to run.
I would like to show a progress bar, indicating the execution of this macro.
Can anyone indicate how to do this ?
Thanks.