Posted to microsoft.public.excel.programming

Mark Warner[_2_] Mark Warner[_2_] is offline

external usenet poster

Posts: 4

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Integrating xls with vba	coder_arun[_12_]	Excel Programming	0	August 22nd 06 03:24 PM
Integrating a work sheet into another	Amature Amy!	Excel Discussion (Misc queries)	0	July 27th 06 08:28 PM
integrating row number in a formula	Grymjack	Excel Programming	2	June 8th 06 01:57 AM
Integrating variables in formulas in VB???	thorsten	Excel Programming	2	May 16th 06 08:42 PM
URGENT !!! Integrating Axes	Debi	Charts and Charting in Excel	1	July 23rd 05 02:53 PM

All times are GMT +1. The time now is 04:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us