HOW TO CARRY A VAIABLE RESULTS FROM EXCEL SHEET PROCEDURE TO A MODULE
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
|