LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default Memory problem (I think ???)

Thanks keepITcool. That's very interesting. Unfortunately, I don't think it
is responsible for my problem however. There are only typically about 10
areas involved. I intend to experiment with your suggestion just in case
there is some interaction with the issue you describe and some unknown.

I experimented with not using the Cut method and only hiding/unhiding rows
(i.e. conventional filter/unfilter) and left the Union code the same.
Execution was excellent (< 1 sec) and it did not become progressively slower
with multiple executions. This seems to prove that it is the Cut method that
is the problem. It was also worse when I inserted/deleted cells to move the
contents in an earlier version. As I mentioned, leaving the contents within
the visible range, even if hidden, results in a scrolling problem if there
are enough hidden rows. So this isn't the desired solution.

Best regards,
Greg

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it memory problem? Adrian T[_2_] Excel Programming 1 July 27th 04 03:53 AM
Out of Memory Problem Todd Huttenstine Excel Programming 1 April 16th 04 08:19 PM
Memory problem Lionel Fridjhon Excel Programming 1 April 1st 04 08:33 AM
Memory Problem ExcelMonkey[_21_] Excel Programming 9 January 31st 04 05:06 AM
Memory problem Stephen W. Smith Excel Programming 0 December 10th 03 10:46 PM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"