Hello,
I have an array that I am unpivoting data for entry in Power Pivot. For some of the rows, I can merely copy and paste the row quickly using a range. I use the code to transfer the array to two columns in the final sheet.
Data = wsCalc.Range("E6:F2000").Value
wsNew.Range("D2:E" & RowLen + 1).Value = Data
The problem is - when I copy, because it is a number, Excel seems to want to paste as a number (it is really a unique indentifier). Probably a simple issue but I want it to be output as text. I tried to put CStr around the first line (wsCalc.Range("E6:F2000").Value) but that crashes Excel. Is there a way so that the final data that hits the sheet is text?
Thanks!
I have an array that I am unpivoting data for entry in Power Pivot. For some of the rows, I can merely copy and paste the row quickly using a range. I use the code to transfer the array to two columns in the final sheet.
Data = wsCalc.Range("E6:F2000").Value
wsNew.Range("D2:E" & RowLen + 1).Value = Data
The problem is - when I copy, because it is a number, Excel seems to want to paste as a number (it is really a unique indentifier). Probably a simple issue but I want it to be output as text. I tried to put CStr around the first line (wsCalc.Range("E6:F2000").Value) but that crashes Excel. Is there a way so that the final data that hits the sheet is text?
Thanks!