The following line of code pulls a range of cells containing text:
Code
Sheet1.Range("BM2:BM" & dLastRow).Value = .Range(.Cells(2, rFindRange.Column), .Cells(dLastRow, rFindRange.Column)).Value2
Some of these cells in the source file have wraptext on. I thought value2 would exclude something like that, but it seems to still pull. Is there a way to avoid that, or could I be doing something else wrong?"