Prev: open word file
Next: Restricting pasting, except for Paste Values
From: ordnance1 on 17 Apr 2010 19:19
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

From: ozgrid.com on 17 Apr 2010 21:29
TextBox100.Value = Range("Q4")


--
Regards
Dave Hawley
www.ozgrid.com
"ordnance1" <ordnance1(a)comcast.net> wrote in message
news:6FE786E2-ACEC-4AE5-959E-FFEAA22DBA45(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: open word file
Next: Restricting pasting, except for Paste Values