Thread: Integrating data into VB code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Warner[_2_] Mark Warner[_2_] is offline
external usenet poster
  
Posts: 4
Default Integrating data into VB code
I need a bit of help, obviously. I want to retrieve a data value from a cell
which is the NAME of a worksheet. I want to integrate that retrieved value
into the VB code to either HIDE or UNHIDE the sheet. I have this:

Dim code As Integer
code = Worksheets("HOME").Range("C4").Value '(which equals 160628)'

I want to take that value of 160628 and get it into this type of code
replacing the "HOME" section:
Sheets("HOME").Visible = True
Thanks.
Reply With QuoteReply With Quote