Thanks, but that is not correct and it may not be apparent from my post, but
"msSheetName" is string variable and therefore does not take the quotes.

Thanks anyway for your post.

"Alan Beban" wrote:

quartz wrote:
I am using Office 2003 on Windows XP.

A one-dimensional array (i.e. the array has one column of data in multiple
rows)
That is not a one-dimensional array; it is a two-dimensional array.

is loaded from a custom function. This array holds a list of all the
file names in a folder that the user selects.

When I try to use the "Resize" method to shotgun the data into a sheet I get
a "subscript out of range" error. The error appears to be in the second
"UBound" clause in the following line:

Sheets(msSheetName).[A1].Resize(UBound(mvaFileName, 1), _
UBound(mvaFileName, 2)).Value = mvaFileName
. . .

No, the error is that you need Sheets("msSheetName") instead of
Sheets(msSheetName)

Alan Beban