Mark, Let me thank you for you a well thought out reply, appreciate it.
Yes, I can see there is potential for a lot of "fun" in terms of column management. I will write up a Utility class to help with this and throw it to the list.
My only fear is that, while technically feasible, its going to be horrendously slow with large sheets; particularly if you are inserting/deleting columns near the left as oppose to the right.
thanks and i will let you know how i get on, alan http://alan.blog-city.com/ MSB wrote:
.....and, I should have made it clear that removing a cell will not cause those cells to it's right top automatically re-number themselves and so effectively remove the column for you. You will still need to move these cells to the left manually so to speak; well at least I think that you will have to.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
