Populate Array then Display in MsgBox

I need to populate an array then put the array info into a MsgBox.

This is what I have so far, but it's got problems. I need help getting this to work.

Please Login or Register  to view this content.

Hi

You haven't dimensioned your array hence it isn't working. Is Expiration_Dates a single column range? If so this should work:

Please Login or Register  to view this content.

You may well want to tweak the output as I wasn't sure what your last loop was meant to be doing.

Richard

Thanks Richard,

In the last loop I was just trying to get the data from the array into a variable to display in the MsgBox.

I seem to be having some error with the code you gave me, ie.

Please Login or Register  to view this content.

I get the error variable required, can't assign to this expression

My spelling fix didn't help.

Thanks.

Oops - my fault for not testing it. Try this:

Please Login or Register  to view this content.

Richard