-
Dera Paul, dear rlv,
Thank you both for your further comments, very much appreciated.
Both the Debug.Print as well as the DoEvents are new for me but very interesting and helpful, thanks for that. I have managed to get the file treated 100%, so that's great!
Code is still running slowly though so I am doing some further research to improve the macro. I noticed for example that the loop that resizes the line height runs superfast at the beginning but then slows down (a lot!) the further it gets through the file (around 3000 lines in total, at the beginning of the code it takes less that a second for the resizing per line, at towards the end it's around 10 seconds...). So I am trying to improve loop after loop to improve handling time. Will let you know when I have the final solution/code but so far your tips have been very helpful, thank you!
My best,
Reno
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules