Mark,

I like your Worksheet Change idea. One question : the code End(xlUp)(2)
is the same as End(xlUp).Cells(2, 1).Value (I worked out, eventually!).
Is the (2) some shortcut notation?

Yes, it is shorcut notation. You don't need the .Cells, or the default when
it is 1.

Range("C65536").End(xlUp).Cells(2, 1).Value
Range("C65536").End(xlUp)(2, 1).Value
Range("C65536").End(xlUp)(2).Value

are all the same.

Likewise, these

Range("C65536").End(xlUp).Cells(1,2).Value
Range("C65536").End(xlUp)(1,2).Value
Range("C65536").End(xlUp)(,2).Value

are all the same, too.

HTH,
Bernie
MS Excel MVP