Hi All,
I've got some code, part of a much larger macro, that is supposed to read some cells into an array to save them (while they are deleted and replaced later). The contents are text (multiple words), but only the first word makes it into the array. What's the problem?
FirstTempCell is a variant that is set by a Find() before this snippet:
Thanks!
I've got some code, part of a much larger macro, that is supposed to read some cells into an array to save them (while they are deleted and replaced later). The contents are text (multiple words), but only the first word makes it into the array. What's the problem?
FirstTempCell is a variant that is set by a Find() before this snippet:
Code:
For j = 0 To 10
Headers(j) = Cells(FirstTempCell.Row, FirstTempCell.Column + j).Value
MsgBox Headers(j)
Next j
Thanks!