Folks,
My code snippet is attached below. Notes follow.
I am working on a range of less than 50 rows on a single worksheet. I have screenupdating turned off. Even so, this macro seems to take forever (in computer time). This is the only thing the macro is doing, so I think I may be using a poor choice of syntax. Any help would be appreciated. Thanks in advance.
Conor.
FYI - OrderQuantities is a named range one column x 45 rows
Please Login or Register to view this content.
Last edited by VBA Noob; 07-09-2007 at 03:28 PM.
Hello Conor,
The reason it takes so long is you are hiding the cells. Each time a cell is hidden, the data in other columns on that row has to be shifted. It would much faster to hide the column of your named range.
Sincerely,
Leith Ross
Use SpecialCells
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks