Hi Bob, many thanks for your kind interest in this problem.
I initially meant that the range "r" actually changes throughout the code. But I believe you meant defining the ac right up the top of the cdoe, where "r" is first defined, not at the bottom. As such, your method indeed will work. Please correct me if I misunderstood you.Originally Posted by xld
Bob, md. I hope taht when I meant to use Johnske's Addin example that i did not come across that I had any issues with md's approach in anyway.Originally Posted by xld
Bob, I wasn't sure what you had meant by:
As such I searched around anf found that johnske had done it in his generic Add-in creation template. However adding in this code required all the other modules in that article (from what I could understand), and as such, I thought to ask you both for the article, so that I could amend it appropriately. Though it seems that the solution may be a quick addition to md's existing add-in event code.Originally Posted by xld
Could you please assist with this code Bob?
Also Bob, thank you for your elegant code in post #28. I was wondering when I was going to see your solution with Enums .
Based on some testing, I was wondering if it could be corrected for the following issues:
I always love reading your great code, I am keen to understand how it could be adapted for the above changes.
- single row selected - as per Malcolm's reference to post #27, which malcolms code addresses.
- checks it will fit on sheet
- check that only a range is selected
- multiple areas selected
- multi-row and multi-column block uses first column only