View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default send sub routine variable to global

Make it a function and return that value as the function result to the
caller.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Nigel" wrote in message
ups.com...
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?