Hi,

I have Macro1 and Macro2.

Macro2 repeatedly calls Macro1, and after each execution attempts to draw
some values from several variables in Macro1. Of course, it fails because I
don't know how to declare those variables in Macro1 so they can be used by
Macro2...

I've read the help and tried declaring them with Public statement, but it
doesn't work, cause apparently I'm doing it at a wrong level. I'm quite new
to the concept of VBA, so this whole levels, modules & whatnot thing is
totally lost upon me... :)

Could somebody try to explain it to me how and where to declare those global
variables so I can use them in both subs (macros).

thanks in advance