TextBox100.Value = Range("Q4")


--
Regards
Dave Hawley
www.ozgrid.com
"ordnance1" wrote in message
...
The code below works great, that is until I hide column Q. I do not want
the data in column Q to me visible on the worksheet. Is there any way
around this problem?


TextBox100.Value = Range("Q4").Text
TextBox200.Value = Range("Q49").Text
TextBox300.Value = Range("Q94").Text
TextBox400.Value = Range("Q139").Text
TextBox500.Value = Range("Q184").Text
TextBox600.Value = Range("Q229").Text