Need to optimize the small macro

hi, Carnifex930, can you post sample workbook? If you know VB, use arrays it should be quicker

Originally Posted by watersev

hi, Carnifex930, can you post sample workbook? If you know VB, use arrays it should be quicker

This site won't let me upload. Says I'm missing a security token. No VB knowledge. You think it would be faster if I put everything in an array?

I have no doubt about it that it will work faster.

please check attachment, run code "test", the output comes on a new sheet, hope this helps

Originally Posted by watersev

please check attachment, run code "test", the output comes on a new sheet, hope this helps

Thanks! I just ran it, and it did the whole thing in 15 seconds.

There is no need, as you have done enough already, but if you don't mind putting some comments into the neat code snippet you wrote so us new guys can learn from it. I am somwhat confused by the code as you use a variant, but it never gets declared, and I have never seen ":" notion used in code before. Again youve done enough already, so any extra input is much apreaciated. Thanks.

Please Login or Register  to view this content.

Haha Carnifex!! Im still learning alot of stuff as well tried stepping through the code at run time and still lost trying to figure it out.

Very Tidy looking code tho Watersev

hi, Carnifex, I will try though the comments will be rather short as I do not know how to explain that

Please Login or Register  to view this content.

Hope this helps

I suggest optimization to my code, please try it, it should be a bit more faster, see attachment

if you are happy with the offered solution, please mark the thread as solved (see Forum rules for details)

Originally Posted by watersev

if you are happy with the offered solution, please mark the thread as solved (see Forum rules for details)

I would love to. Where is the link to mark as solved? I don't see it.

Go to the first post you made in the thread click edit and then change the prefix beside the title

Originally Posted by radar_jynx

Go to the first post you made in the thread click edit and then change the prefix beside the title

Ah thata annoying, the small button the right lets you go to advanced where you can change the prefix.