S
Scott
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
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