Simplify Code

[declan1983]

Hello,

This piece of code that I stuck together seems to work quite well, I am somewhat of a VBA hack though and while I can make stuff work it tends to be quite brute force, I was wondering if this can be simplified?

Please Login or Register  to view this content.

[mehmetcik]

With a bit of thought your code would be a lot simpler and faster.

Please Login or Register  to view this content.

[Dante Amor]

Another alternative:

Please Login or Register  to view this content.