Messagebox To Contain Cell Contents Of An Array

[Philb1]

Hello
I want to show the contents of an array that gets populated if there any errors produced during the process of running 7 modules daisy chained together. I've got it working as I would like. I did originally try to get it to work by referring to the array by it's name (The commented out line). It doesn't matter how I try, I can't get it to work. Yet if I refer to it by it's address, it works. Wsht7 is activated at the time this is called & I found the code below whilst Googling.
Any Ideas please

Please Login or Register  to view this content.

[Andy Pope]

You need to explain what ErrorCol is. But the syntax is more likely to be

Please Login or Register  to view this content.

[Philb1]

Hi Andy
I've had a play & got it to work 3 different ways. None by referring to the range name. I've knocked up an example of what is in my macro & attached it for you have a play. I'll have another look tomorrow as it's bed time here
Thanks for looking

[Andy Pope]

Problem with title being used to define buttons due to missing comma

Please Login or Register  to view this content.

[Philb1]

Thanks Andy.. I'd been through it more than once & every time it complained an object was missing. I thought I'd tried everything, I didn't.
Thanks for your help
Phil