LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default To detect changes in a worksheet

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
detect when columns being written to a worksheet “cross” a vertical page break gkb_cardiff Excel Worksheet Functions 0 November 28th 08 12:29 PM
How do I detect hidden worksheets or hidden data on a worksheet? Alice Excel Discussion (Misc queries) 4 August 24th 06 03:38 AM
How to detect if there is change in any cell vlaue in a worksheet? Ai_Jun_Zhang[_10_] Excel Programming 2 September 20th 05 12:31 AM
Detect macro's parent workbook or worksheet Conceptor[_2_] Excel Programming 1 April 26th 04 10:21 PM
detect worksheet mike allen Excel Programming 2 October 28th 03 10:33 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"