Excel VBA-使用RESIZE“粘贴” - 需要粘贴特殊（科学记数法）

I'm using the following code which was based on someone else's post on SO. It opens another workbook, copies a sheet and pastes it back into a main workbook. It's "pasting" these values with the resize function, so pastespecial isn't available. The problem is that there are values in the source sheet's S column that are 20+ digits (tracking numbers) and when they get pasted back to the main working book, they are truncated into scientific notation and are lost.I'm using the following code which was based on