Original cumbersome IF structrure(it works but its slow)
Please Login or Register to view this content.
What I'm leaning towards to speed it up:
Please Login or Register to view this content.
Theres a million ways to do this. So I don't know what the best way would be.
Hello ultimastryder,
The quickest way is to apply the change to an entire range at once rather than to each cell individually. This macro turns off the screen updating so the user does not see the changes while they happen. The user only sees the changes after the screen updating is turned back on.
The entire range is first reset to the normal height. The range is then examined for cells with "ADDRESS" in them. When these are found, a new range, RngX, is created. The new row height is then applied to RngX.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks