ExcelBanter - Problem with referencing a hidden column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Problem with referencing a hidden column (https://www.excelbanter.com/excel-programming/441761-problem-referencing-hidden-column.html)

ordnance1[_2_]

Problem with referencing a hidden column

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

ozgrid.com

Problem with referencing a hidden column

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

All times are GMT +1. The time now is 01:50 AM.