Search results for query: *

Application.MacroOptions with ArgumentDescriptions worked as you advertised earlier. This method applied to Excel 2010 does exactly what Laurent's add-in does. Fortunately i'm an excel 2010 user :) The problem was that I mis-thought i had to rerun the containing subroutine every time the...

Great combo, now i start to see some light in the end of the tunnel. I managed to add a description to my function, but i'm having troubles understanding what exactly you mean in the statement about messages. The description is available indeed just if one uses function wizard. Is there any...

Thank you very much combo!! That's fantastic! My star goes to you. I have made some small additions to the code to avoid the selection of ranges that have different sizes. The code seems to be working, although it's been hard to believe it a couple of hours ago. Anyway, i'm not that sure if the...

Thanks for feedback SkipVought! I need it as VBA to ease the work and automate the process. Certainly you can fix it manually by typing a formula on the sheet, but this is simply not an efficient way of doing it as you always have to manipulate huge amounts of data (for example 1-2000 lines...

Hi everybody, I need some guidance on how to make the above formula work. I've been struggling with it for a couple of days now. I'm not a coder, but i tried to use different samples and tutorials i found online. Aparently is quite difficult to think out of the box and find the right...