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: 686

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.

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.

Your Answer

Please login to post answer

Tagged:set statement global local

Previous Post:

naming sheet object and calling it by that

Next Post:

Copy & Paste ( pictured image ) ?

Can't get local yp domain: Local domain name not set

jdbc and statement.executeQuery() throws, statement.execute() doesn

Add-Ins loaded into Excel

help with IF statements

on If statement in a macro ?

Excel VBA - need to copy paste conditional statement

Help with nested if statement - with and & or

Help on some code - like an "if" statement

making a spreadsheet cell name a global variable in the VBA project

BIND 9 only knows global IP but doesn't know internal LAN IP whose private IP

Find Word from long statement

Answering message box with visual basic statement

if statement based on Shapes.Value

Mid statement

If statement in a macro ?

Global Variable

statement.executeQuery() Error

statement.executeQuery() crashes query if no records found

Math statement process

problem while using el statement

preparedstatement VS statement

Project Statement

significance of the statement "public static void main(String []args)"

missing RETURN statements

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us

MS Office Forum

set statement in global rather than local

1 Answer Found

Your Answer

Related Post