Hi Patrick,

I cannot duplicate your problem. I experience no difficulty in populating a
textbox with text from a hidden column.


---
Regards,
Norman



"Patrick Simonds" wrote in message
...
I am using the code below to populate the TextBoxes of my UserForm. My
problem is, that "TextBox3.Text = rng(1, 4).Text" refers to a hidden column
so nothing appears in the TextBox3. Is there away around this? While I need
the data in column 4, I do not need it to show on the worksheet.

TextBox1.Text = rng(1, 1).Text
TextBox2.Text = rng(1, 2).Text
TextBox3.Text = rng(1, 4).Text