Hi there,
my macro performance is really bad. Does anybody have a clue to make it faster?
Please Login or Register to view this content.
Hi there,
my macro performance is really bad. Does anybody have a clue to make it faster?
Please Login or Register to view this content.
Showing/Hiding columns takes some time.
Especially if screen updating is on.
So first - use
at the beginning of the codePlease Login or Register to view this content.
and then
turn it on at the end
The next step could be hiding/showing sets of rows/colums at once instead of looping through.
Best Regards,
Kaper
See if this works for you.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks