thanks dear
On Mon, Jun 5, 2017 at 4:03 PM, Sandeep Kumar Baranwal <
sandeepkumarbaran...@gmail.com> wrote:
> Hi
>
> The excel processes at speed relative to its size.
>
> With Macros, the excel size tends to increase, which may lower the speed
> of its processing.
>
> In general, it being slow o
thanks for the post
On Mon, Jun 5, 2017 at 8:32 PM, Paul Schreiner
wrote:
> There are LOTS of reasons why macros can be slow.
> And.. "slow" is relative.
>
> I have a workbook with over 130,000 rows and 72 columns.
>
> I can report summaries for these rows in SECONDS.
>
> my macro USED to take s
There are LOTS of reasons why macros can be slow.And.. "slow" is relative.
I have a workbook with over 130,000 rows and 72 columns.
I can report summaries for these rows in SECONDS.
my macro USED to take several minutes, but I simplified the code and found that
it was looping through the lines eve
Hi
The excel processes at speed relative to its size.
With Macros, the excel size tends to increase, which may lower the speed of
its processing.
In general, it being slow or fast with or without macros is a relative
experience.
If there are lots & lots of formulas and excel size is very high (
