Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for range interestion recommendation
Hi, and thanks in advance for any help provided.
GENERAL OVERVIEW: I have a Named Range in my spreadsheet, SourceData. I'm utilizing the Worksheet_Change event to update the rows in SourceData. However, there is the slight (probably remote) possibility that someone change random cells all over this range at random. For example, the follow could be the values for Target.Address, all of which fall in the SourceData range: Target.Address = $G$3 Target.Address = $N$8:$P$17 Target.Address = $O$8,$P$10,$N$10,$N$12,$P$12,$O$14,$O$16 I'd guess that a single cell to occur about 85% of the time, one area of multiple cells to occur about 14% of the time, and several areas of cells to occur on occasion (say 1%). WHAT I'M DOING: I am updating the *entire* row whenever any cell in that row has been changed. WHY I'M ASKING FOR HELP: I am wondering if anyone knows a better way to do this (the one way I've thought of is to create an array, loop through all cells to set the position in the array to TRUE if encountered, and only update based on that -- which isn't bad). One other alternative is I could just loop through for each active cell, but particularly when a whole region has been modified, this can result in a lot of unneeded work. Essentially, I'm looking to see if there is something better that I haven't thought of, or don't know of. Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Book recommendation | New Users to Excel | |||
Need a simple recommendation | Excel Worksheet Functions | |||
Book Recommendation | Excel Discussion (Misc queries) | |||
Help / Recommendation | Excel Worksheet Functions | |||
Book Recommendation?? | Excel Programming |