I would think that you'd need to put this in a string in the first cell, but there is the limit of 32,767 characters max as the contents of the cell. I don't suppose you know the total number of characters of the list ( + 1799 extra for the semi-colons )?
Writing a macro to stuff them all into one row of an output file still has the limit of 32,767 characters ...
Open pathname For mode [Access access] [lock] As [#]filenumber [Len=reclength]
The Open statement syntax has these parts:
pathname Required. String expression that specifies a file name¾may include directory or folder, and drive.
mode Required. Keyword specifying the file mode: Append, Binary, Input, Output, or Random. If unspecified, the file is opened for Random access.
access Optional. Keyword specifying the operations permitted on the open file: Read, Write, or Read Write.
lock Optional. Keyword specifying the operations permitted on the open file by other processes: Shared, Lock Read, Lock Write, and Lock Read Write.
filenumber Required. A valid file number in the range 1 to 511, inclusive. Use the FreeFile function to obtain the next available file number. reclength Optional. Number less than or equal to 32,767 (bytes). For files opened for random access, this value is the record length. For sequential files, this value is the number of characters buffered.