| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden Column A Problem | Excel Discussion (Misc queries) | |||
| CountIf formula problem when referencing a column. | Excel Discussion (Misc queries) | |||
| 2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
| referencing a cell in a hidden sheet | Excel Programming | |||
| referencing hidden sheets | Excel Programming | |||
![ordnance1[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
