I've set up two macros "A" and "B" for use on a worksheet.

I assigned a value say 4 to a variable "v" in macro A.

I find that the value 4 does not carry over to a variable "v" in
macro B.

Is there a way to have the variables of macro A apply to all other
macros used with the worksheet?

Thanks,


Ed

DIM the variable before the macros in the module:

DIM v
Sub a()
..
..
..
End Sub
Sub b()
..
..
..
End Sub
--
Gary''s Student


"Ed" wrote:

I've set up two macros "A" and "B" for use on a worksheet.

I assigned a value say 4 to a variable "v" in macro A.

I find that the value 4 does not carry over to a variable "v" in
macro B.

Is there a way to have the variables of macro A apply to all other
macros used with the worksheet?

Thanks,


Ed

"Ed" wrote in message
...
I've set up two macros "A" and "B" for use on a worksheet.

I assigned a value say 4 to a variable "v" in macro A.

I find that the value 4 does not carry over to a variable "v" in
macro B.

Is there a way to have the variables of macro A apply to all other
macros used with the worksheet?

If the macros are in one module: put a 'Dim v' statement at the beginning of
the module (in the General section). Your variable will be recognizes in all
macros (do not but a Dim v statement into any of your macros, this would
override the general declaration.

If macros are in separate modules, put a 'Public v' statement into the
general section of any module.

Joerg