srbball790

Does anyone know how to call a varaible in a macro from another macro?

Say the variable in one macro turns out to be some value x. I will want to use that same variable in another program, but I do not know how to do it.

Any help is appreciated. Thanks.

Bob Phillips

Declare it as a Public variable.

Owen Sparks

Howdy. A little more information is required.

Where do you want to re-use this variable:-

(a) In another sub in the same module.
(b) In another module within the same workbook.
(c) In a seperate workbook.
(d) In a different program altogether.

O.S.