Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nancy Thomas   on Feb 04 In MS Office Category.

  
Question Answered By: Joseph Evans   on Feb 04

Yes, I like to set  things up that way too. You can use a hidden
sheet to store all the settings and variables. Once you have given
the cells  names, you can access  them using the Range method as shown
below. Using names  rather than absolute cell  addresses also allows
you to rearrange your admin  screen at will without messing up the
code.

Sub Test1()
Range("MyCell1") = 12
End Sub

Sub Test2()
MsgBox "MyCell1 = " & Range("MyCell1")
End Sub

Share: 

 
 
Didn't find what you were looking for? Find more on new to vba programing Or get search suggestion and latest updates.


Tagged: