P.S. "$A$1" is an absolute cell reference. "A1" is a relative cell
reference. For example, if you copy a formula in cell B1 containing "$A
$1" to cell B2, the formula in B2 will reference A1. If you copy a
formula in cell B1 containing "A1" to cell B2, the formula in B2 will
reference A2 instead.

I don't know why a Change event uses $'s, but believe it's a given.

Hth,
Merjet