Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

set statement in global rather than local

  Asked By: Maddison    Date: Mar 11    Category: MS Office    Views: 859
  

Is it possible to declare s1 as global rather than local in the
following statement

Set s1=worksheets("input")

When I tried to declare this statement in declarations, VBE gave error.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Connie Wallace     Answered On: Mar 11

Put it at the top of a module and use Public rather than Dim.

 
Didn't find what you were looking for? Find more on set statement in global rather than local Or get search suggestion and latest updates.




Tagged: