Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Public variables | Excel Discussion (Misc queries) | |||
Public Variables | Excel Discussion (Misc queries) | |||
Declaring variables in Module vs. Public | Excel Discussion (Misc queries) | |||
Using A Public Function / | Excel Worksheet Functions | |||
Public Curiosity | Excel Discussion (Misc queries) |