View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default STATIC VARIABLE NOT AVAILABLE IN ANOTHER MODULE

DEAR ALL

I have declared in one sheet -varchk- variable as public and in the
sub procedure declared it as static -static varchk-. I am carrying the
results in a worksheet to another module thro this static variable
varchk. But the value of this varchk is not showing in the sub
procedure in the module. Pls adv.