Results 1 to 5 of 5

Public Worksheet Declaration

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2005
    Posts
    146

    Public Worksheet Declaration

    I'm using a public declaration for a worksheet but I seem to have to initialize it in each routine. Is there a way to set it and leave it?

    So in a module I have:
    Public BI as worksheet
    
    Sub Prog1()
       Set BI = sheets("BasicInfo")
    
    'code
    end sub
    
    Sub Prog2()
      Set BI = Sheets("BasicInfo")
    
    'code
    end sub
    Last edited by wilro85; 08-28-2009 at 07:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1