entire cell contents not getting into string array...

[silkworth]

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:

                For j = 0 To 10
                    Headers(j) = Cells(FirstTempCell.Row, FirstTempCell.Column + j).Value
                    MsgBox Headers(j)
                Next j

Thanks!

 

[schielrn]

Are the words you are trying to add actually accross columns? Just want to make sure as you are incrementing the column counter. Your not receiving any errors are you? If not then I assume you ahve declared your array large enough.

 

[silkworth]

Yes, they are actually in separate columns - originally not, I use TextToColumns to explode them from copied-in csv data, but I looked at the data after TextToColumns but before the above code, and they're definitely properly split up. Seems like it's seeing the space and recognizing that as the end of the contents or something.

 

[silkworth]

Ah...nevermind...I found my problem. An errant " *" in a search and replace just before this code was deleting all but the first words...d'oh!