Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have defined public arrays to keep in memory user data
entered in Sheet1. I need to have these data erased from memory as soon as new data is entered in that worksheet. For that, I can use something like: public function f() ? for i=1 to 12 indicator(i)=0 next i end function I don't have the knowledge to write the missing statement. I suppose it involves Worksheet_Change. Can someone help me with that, please ? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
detect when columns being written to a worksheet “cross” a vertical page break | Excel Worksheet Functions | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
How to detect if there is change in any cell vlaue in a worksheet? | Excel Programming | |||
Detect macro's parent workbook or worksheet | Excel Programming | |||
detect worksheet | Excel Programming |