Oops, I meant to remove that line. The problem is with the "OldValue"
variable.
BTW, OldValue is declared as a string; OldRange is declared as a
Range. I don't think I'm using OldRange properly, but that's another
issue.
Paul Schreiner wrote:
> I think I've found the source of your problem.
>
>
I think I've found the source of your problem.
it has to do with the line:
Set OldRange = Target
in this case, once you've issued this command,
OldRange will "automatically" update to whatever the
value of "Target" is.
the command doesn't HAVE to be reissued.
You have essentially "ASSIGNED" to va
