If you're just copying and pasting, copy the information inside the
cells instead of the cells themselves. You'll have to do that one at a
time. If you're doing something with VBA, do something like this:

var1 = Cells(1, 1).Value & Cells(1, 2).Value & Cells(1, 3).Value
TextBox1.Text = var1

- Pikus


---
Message posted from http://www.ExcelForum.com/