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