skulakowski
04-15-2005, 09:52 AM
List(q) is a string array so reading the number 2 into List(q) gives me the text 2. This is exactly what I want.
However, when I write List(q) back out into my spreadsheet, VBA gives me the number 2. This is not what I want.
Any ideas how I can force List(q) to return text strings to me and never numbers?
ReDim List(0 To j) As String
For q = 0 To j
List(q) = Cells(q, 1)
Next q
' do other stuff with List(q) but NEVER touch the intial entry
For q = 0 To j
ActiveCell.Offset(q, 0).Value = List(q)
'tried ActiveCell.Offset(q, 0).Formula = List(q) but .Formula didn't help me
Next q
However, when I write List(q) back out into my spreadsheet, VBA gives me the number 2. This is not what I want.
Any ideas how I can force List(q) to return text strings to me and never numbers?
ReDim List(0 To j) As String
For q = 0 To j
List(q) = Cells(q, 1)
Next q
' do other stuff with List(q) but NEVER touch the intial entry
For q = 0 To j
ActiveCell.Offset(q, 0).Value = List(q)
'tried ActiveCell.Offset(q, 0).Formula = List(q) but .Formula didn't help me
Next q