send sub routine variable to global

Posted to microsoft.public.excel.programming

Nigel[_27_] Nigel[_27_] is offline

external usenet poster

Posts: 25

send sub routine variable to global

so in a subroutine, i set a variable in the middle of script, and
aftewards, i wanted to use that variable globally....can i take a
variable and set a global variable with it from inside a subroutine?

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
Global variable	dhstein	Excel Discussion (Misc queries)	2	October 30th 09 01:03 PM
Error #1004 routine send emails	Gus[_2_]	Excel Discussion (Misc queries)	0	June 7th 07 01:23 AM
How to keep a Variable alive after a Call to Sub Routine	Dennis	Excel Discussion (Misc queries)	2	July 27th 05 10:57 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM
VBA routine to assign first name only to a variable	fitful_thought	Excel Programming	6	August 3rd 04 01:39 PM

All times are GMT +1. The time now is 07:17 PM.

Menu

About Us