On Feb 2, 11:33 pm, "Dave O" wrote:
One way to do it is to assign the value to a named range, which will
maintain the value even when other routines have ended (and hence
would not be able to carry the value on to other routines). Add this
line to the code that determines the value:
Names("nrCgoFigs").Value = cgofigs
Other routines can then refer to Names("nrCgoFigs").Value.

Dave O

D/DAVE
Thnks fr quick response. At present I am doing like that -- assigning
it to one of the cells and calling it. But for knowledge sake i want
to know how to do it thro calling that variable from excell sheet
procedure into module procedure. Pls adv