Hi Matt,

Thanks for the explanation. I was not questioning the intent just pointing
out that it might lead to an alternative approach.

Yes, you will have to use some form of checking to see if the comments
column exists or not. Or, you could force it to exist. Create the 5 headers
in row 1 of your updates worksheet.

Also, I don't know how you are creating the body of the email. If you treat
the updates worksheet as a ADO data source, you could use the GetString
method of the ADO recordset object and get the HTML for the table in a single
step.

And, as for being stressed goes, hopefully, you'll get this problem
straightened out and lower your stress level. That is...
....
....
until the next problem comes along. ;-)

"Matt Jensen" wrote:

{snip}
I did read your post, I just didn't see any "need" for XL/VBA to resize my
array that I explicity dimensioned nor did I understand why - I guess I'll
just have to take this fact for granted though.

{snip}
Just stressed at the mo - sorry!

{snip}