Problem with referencing a hidden column

  • Thread starter Thread starter ordnance1
  • Start date Start date
O

ordnance1

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
 
Back
Top