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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embedded Combobox (Form Control) 4
Help- Simple function fails working with pasted values 4
Pass variables to Worksheet_SelectionChange 3
Problem sorting a range of columns using VBA 1
Need help using nameranges to write to columns 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Problem with advanced filter macro 8
Array problem 1

Back
Top