On Feb 3, 12:07 am, "Dave O" wrote:
Routines can pass public variables back and forth but only when all
the routines in question are running. That's why the named range
technique works- because the value persists in memory even when the
routine that generates it has ended.

If the value of cgofigs is written to a cell or is the result of a
formula in a cell, a routine can refer to the value of that cell:
Range("'sheet1'!b2").Value

D/DAVE
Thank you and I got better solution than i asked for. I tried your
sugestion and it is great.
I did it the way u sugested but confirm my steps right or not. In the
activesheet i assigened a cell and given it the name nrCgoFigs. And
in the code i hv added what u sugested. Names("nrCgoFigs").Value =
cgofigs .