Quote Originally Posted by xld
It is not that I am so busy, but I have difficulty getting internet access at the moment, I only get about an hour a day at the end of the day.

On the first point, sometimes by creating functions it can actually make the code less manageable IMO, it makes it harder to see exactly what is going on. But ... as this seems tobe where you want to go, and that is your prerogative, I would return to my way of doing these things which is with a class module. I would have a class that manages all of the chart properties that I am interested in, and then just change ranges and so on as a property of the class.

On the second one, again I would think that would be nicely handled as properties of the class.
Hi Bob,

Glad you are back. First off I understand completely. When I said you were probably busy, I just meant you may have limited time to look into these problems given your work Schedule, or in this case your internet access. I hope all is well with you.

With regards to the above, could you please given me an example of the class. I am really keen to learn. If you feel the class module is a better way to manage chart properties that then that would be a great thing to know. I am only really starting to appreciate the Object model and the power of classes, and realising that effectively whenever one refers to a workbook object, they are simply calling on an instance of that class. So our previous discussios on class modules are starting to sink in (albeit slowly ).

regards,