VBA Code for type casting arrays

[Vaslo]

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!

 

[Norie]

Format the destination range as Text before you put the data from the array in it.

 

[Vaslo]

Format the destination range as Text before you put the data from the array in it.

Do you mean manually or with code?