I've never seen this happen.

Can you post the snippet of code that is affected?

Any chance that you have a misbehaving event macro that's really doing the dirty
work of clearing those variables.

johnny wrote:

Hi,

When I use ActiveSheet.Copy to copy the current sheet to another
sheet, all the public variables or global variables are reset to 0,

anyway to avoid this or keep the public variables values when coping ?

Thanks.

Johnny.

--

Dave Peterson