That stops the errors, but the formatting doesn't seem to work appropriately.
I take a list:
5
9
8
7
8
9
copy it, then select the ExcelPaste, and I get:
(' 5
9
8
7
8
9')
the pasteoptions version puts:
(5, 9, 8, 7, 8, 9)
I've tried putting additional values in, but I never seem to get the...