Quote Originally Posted by xluser2007
Just with regard to my earlier post, a few queries:
In haste, I'm gone 'til Monday or Tuesday.
Quote Originally Posted by xluser2007
When the user selects a block of contagious cells e.g. 3 rows * 4 cols, could the triangle be made to start from the first Column only?
Yes, start with Selection.columns(1).select. But with all this swine flu about I wouldn't want to be anywhere near these cells.
Quote Originally Posted by xluser2007
If the user selects non-contagious cells e.g A1:A5, B1:B5, E10:E15, could the traingle be made to start from the first area i.e. A1:A5?
Possibly, with the likes of Selection.areas(1).select, but haven't time to test/refine.
Quote Originally Posted by xluser2007
Later, if you have the time, I would love to understand how to consolidate the macros into a single code. I understand that you are busy and fully appreciate your help, but learning this would be a cool thing to know how to do.
I am away for a few days, but if where I'm going has an internet connection and... I'll give it a go.
ps contiguous